Coding for Database Connection. (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


musicalbell -> Coding for Database Connection. (2/28/2008 2:58:43)

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...




mar0364 -> RE: Coding for Database Connection. (2/28/2008 8:27:13)

Hi my name if Rich and I'm an ASP Hack. There are some folks here that are really good but I can help you through this one. You want to use server.mappath. Try this changed in the approriate places for your database and folder.

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_store_STRING
MM_store_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/folder/database.mdb")
%>




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875