Coding for Database connection (Brinkster) (Full Version)

All Forums >> [Web Development] >> Dreamweaver Help



Message

musicalbell -> Coding for Database connection (Brinkster) (2/28/2008 2:55:54)

I'm a beginner learning web design with Dreamweaver MX and now start dealing with database and recordset.

Here's a bit of the background (you may skip this paragraph). At first I have troubles with web server because my WinXP Home doesn't have IIS or PWS, so I went for alternative and installed Apache...BUT it doesn't seem to come with ASP mode. Alas...so I abandon testing server completely and just upload it to the web.

So...here comes a problem when I attempted to upload my asp files to the web. I DON'T KNOW HOW TO DEAL WITH CONNECTION!!! Do I need to change the coding of my connection file? How? Here's my code, can anyone change it for me please.

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connSongofsoul_STRING
MM_connSongofsoul_STRING = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\SongOfSoul\songofsoul.mdb; pwd=cyl12321"
%>

By the way, I got my free web hosting from Brinkster, and they provide me with this link http://kb.brinkster.com/Kb.asp?kb=108078 when i asked for coding support.

Besides the connection file, do I need to change anything to my database .mdb files and the other .asp files?

Please help...especially the coding part...[&:]



Spooky -> RE: Coding for Database connection (Brinkster) (2/28/2008 18:48:48)

It would be something like this: 

MM_connSongofsoul_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

              "Data Source=C:\sites\Single??\UserName\database\songofsoul.mdb;" & _

              "Persist Security Info=False"


However you will need to do this :

quote:

The following path reference is not specific: C:\sites\Single??
Please log into your account, select Website Settings, and use the absolute path to your file structure.




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
9.570313E-02