One of you kindly confirmed what the true OLE DB syntax is for an ASP > ADO
Access DB with password, but I'm struggling to parse this in my ASP page.
FYR, I have it as follows:
strDSN="""Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("mydb.mdb") & ";Jet OLEDB:Database
Password=kitkat"",""admin"","""""
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Mode = 3
oConn.Connectionstring = strDSN
oConn.Open
But when I execute the above I get:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name too long
The path name for the DB is spot on, as it works with the ODBC variant, but
I think it has something to do with my 200 quote marks!
Can u help??
Rgds
Laphan