Using a variable in a db connection string

breeze76 · #1 (**permalink**) 10-22-04, 00:02

I would like to use a variable in my db connection string. Here is what I have:

conn.Open "driver={Microsoft Access Driver (*.mdb)};;dbq=C:\inetpub\projects\; & 'database'"

This does not work. "Database" is a query I am pulling from another page that is the database name with the extension. How do I put it in the connection string?

Thanks

rokslide · #2 (**permalink**) 10-22-04, 00:07

Soemthing more like this perhaps......

Code:

conn.Open "driver={Microsoft Access Driver (*.mdb)};;dbq=C:\inetpub\projects\" & database

breeze76 · #3 (**permalink**) 10-22-04, 00:15

Quote:

Originally Posted by rokslide

Soemthing more like this perhaps......

Code:

conn.Open "driver={Microsoft Access Driver (*.mdb)};;dbq=C:\inetpub\projects\" & database

Tried that, still does not work. This is the error I get when I do that:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x304 Thread 0x61c DBC 0x2925f54 Jet'.
/project_info.asp, line 70

Line 70 in the db connection string...

any other suggestions??

rokslide · #4 (**permalink**) 10-22-04, 00:37

can you do a response.write on your connection string eg

Code:

response.write "driver={Microsoft Access Driver (*.mdb)};;dbq=C:\inetpub\projects\" & database 
conn.Open "driver={Microsoft Access Driver (*.mdb)};;dbq=C:\inetpub\projects\" & database

so we can see what is actually being built??

breeze76 · #5 (**permalink**) 10-22-04, 00:52

that gives me the same error..

Hmmmmm

rokslide · #6 (**permalink**) 10-22-04, 00:56

yes, it would have given you the same error, but is should have also written out the complete connection string that you are trying to use so that you could post it here and we could see what was wrong with it.....

I would have expected you would want something like this for you connection string

Code:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\myDb.mdb;"

rather then

Code:

conn.Open "driver={Microsoft Access Driver (*.mdb)};;dbq=C:\inetpub\projects\" & database

so you might want to try

Code:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\" & Database & ";"

Internet Services

Web Development

Digital Marketing

Consumer Tech