|
| |
|
|
musicalbell
Posts: 2
Joined: 2/28/2008
Status: offline
 |
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
Posts: 3030
Joined: 4/5/2002
From: Florida, US
Status: offline
|
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")
%>
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
