problems with dsnless connection strings

[chrisparr21681]

Dim Conn, dbPath
dbPath = "d:\myaccessfile.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

thats what i have so far, i'm getting this error

Expected end of statement

/index.asp, line 4

dbPath = "d:\myaccessfile.mdb" Set Conn =

 

[DotNetGnat]

Try this:

Dim Conn, dbPath

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE= d:\myaccessfile.mdb"

-DNG

 

[vbkris]

Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

dbPath is in the same line as conn.open right???


Known is handfull, Unknown is worldfull