DSN-less connection strings

[lazydays]

I tend to use DSN-less connections to databases - don't know why, but it just seemed to happen that way!

However, I am designing a site with a datasource directory below the root of the site, and I am having trouble setting up the connection string.

My script is in
root/

http://www.domainname.com/aspscripts/connection.asp

and my database is in
root/datasources/

http://www.domainname.com/database.mdb

Is it possible to connect using a DSN-less connection to this database?
If so, can someone help me please!!!!

 

[FesterSXS]

What problem are you having?

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com

 

[lazydays]

I don't know how to define the connection string.

I thought that the following string would work but it couldn't connect.
objConn.ConnectionString = "DRIVER {Microsoft Access Driver (*.mdb)};
DBQ=" & Server.MapPath
("../datasources/

http://www.domainname.com/database.mdb")

Any pointers would gratefully received!

 

[FesterSXS]

shouldnt ../datasources/www.domainname.com/database.mdb just be ../datasources/domainname/database.mdb??

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com

 

[lazydays]

I have tried that Tony but still no joy
Any other ideas?

 

[amorous]

Try this:

<% ' ASP server-side code
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.MapPath(".") & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd="
%>

This assumes the MDB is in the same directory where the ASP page is running. Also make sure this directory has Write permissions for the user account.

taken from able-consulting.com

-VJ

 

[medic]

Maybe I'm missing some technical facts here, but the hierarchy of your directories/folders looks a little confusing to me. I have a suggestion though.
Use the local path of the database file directly. For example, if your database file is located in C:\INETPUB\DATASOURCES\DOMAINNAME\ folder, use this connection string:

objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source=c:\inetpub\datasources\domainname\database.mdb;"