I am trying to set up a DSN-less connection to a server that I don't know much about. There is a connection string on the server now it looks like this:
<BR>


Sub Application_OnStart

Application("COOKIE_EXP_DAYS" = 2

End Sub


Sub Session_OnStart


Session("asplConnStr"="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/asplogin/asplogin.mdb" & ";"
Session("asplFormPath" = "/asplogin/asplogin.asp"
Session("asplDenyPath" = "/asplogin/aspldeny.asp"
Session("asplExpiredPath" = "/asplogin/aspldeny.asp"
Session("asplInactivePat" = "/asplogin/aspldeny.asp"

End Sub

I want to use the same database that this string is using but I don't want it in a session variable. So I tried to use the "Custom Connection String" dialog box to make a connection to the data base.
<BR>
This is what I enter in the connection string box:
<BR>
"Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/asplogin/asplogin.mdb" & ";"
<BR><BR>When I do that I get this:<BR><BR>
HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem:
1) There is no application server running on the server machine.
2)The application server specified for this site does not map to the ftp.thisurl.com/_mmDBScripts/MMHTTPDB.asp URL.<BR><BR>
I have tried many different ways. I even ran the mappath on the server and got the direct path and it still didn't work.
Any ideas?

Make sure your ISP enables read write execute on your database directory. The default is usually \databases but check with them. I had the same problem, and it worked.

Okay, after messing around with my url prefix setting in the define site dialog I don't get the same error anymore. When I test the connection in the Custom Connection String dialog box I get a "an unidentified error has occurred". When I try to make a new record set in my data bindings it tells me that it's "unable to retrieve tables from this connection,...click on the define button".

Vanelli my be on to something too. I will call the isp to make sure the directory isn't locked down. Any other Ideas?



Edited by - dlofgreen on 04 Apr 2002 18:36:20