|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
DSNless connection to Access Database problem |
|
From: |
Todd Richardson |
|
Date: |
11/30/2000 3:16:08 PM |
|
IP: |
172.131.24.55 |
Let me begin by saying I am fairly new to asp. here is my situation. I have been testing some asp code on my local personal web server before uploading. It beginns like this. (This one works)
<%
Dim DataRS, DataConn
Set DataRS = Server.CreateObject("ADODB.Recordset")
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "DBQ=" & Server.Mappath("members.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
and so on....
where members.mdb is located in the following directory C:\Inetpub\wwwroot\members
My problem is when I try to put the physical path of members.mdb in the above example. Which I will need to do when uploading to my web server. here is how I have been doing it. (after making this change to the above code it no longer return any information, basically it is not finding the database.)
<%
Dim DataRS, DataConn
Set DataRS = Server.CreateObject("ADODB.Recordset")
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "DBQ=" & Server.Mappath("C:\Inetpub\wwwroot\members\members.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
and so on....
|
Follow Up - Re: DSNless connection to Access Database problem - gunther 12/5/2000 10:05:07 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
