Answered
Connection string problems asp
Hi
I have inherited a website and need to make some urgent changes, currently all the recordsets are handcoded and are in an absolute mess, I have upsized to SQL server to allow me to create the new recordsets through DWMX, however the site is a long way from being ready to change over to the new DB and I am unable to connect to the access DB.
The database is an access db with a security.mdw file that controls access how can I make changes to my connection string to connect? I have included my latest effort below.
Dim MM_conTest_STRING
MM_conTest_STRING.Mode = adModeReadWrite
MM_conTest_STRING.Provider = "Microsoft.Jet.OLEDB.4.0"
MM_conTest_STRING.Properties("Jet OLEDB:System Database") = Server.MapPath("***\Security.mdw")
MM_conTest_STRING.Properties("User ID") = "***"
MM_conTest_STRING.Properties("Password") = "****"
MM_conTest_STRING.Open Server.MapPath("***\Database.mdb")
MM_conTest_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("****\Database.mdb")
However this only gets me the following error:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/fporiginal/Connections/conTest.asp, line 9
If I remove everything except the last line I get the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary permissions to use the '(unknown)' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
/fporiginal/categories.asp, line 15
Any help gratefully received
Cheers
Ossie
I have inherited a website and need to make some urgent changes, currently all the recordsets are handcoded and are in an absolute mess, I have upsized to SQL server to allow me to create the new recordsets through DWMX, however the site is a long way from being ready to change over to the new DB and I am unable to connect to the access DB.
The database is an access db with a security.mdw file that controls access how can I make changes to my connection string to connect? I have included my latest effort below.
Dim MM_conTest_STRING
MM_conTest_STRING.Mode = adModeReadWrite
MM_conTest_STRING.Provider = "Microsoft.Jet.OLEDB.4.0"
MM_conTest_STRING.Properties("Jet OLEDB:System Database") = Server.MapPath("***\Security.mdw")
MM_conTest_STRING.Properties("User ID") = "***"
MM_conTest_STRING.Properties("Password") = "****"
MM_conTest_STRING.Open Server.MapPath("***\Database.mdb")
MM_conTest_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("****\Database.mdb")
However this only gets me the following error:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/fporiginal/Connections/conTest.asp, line 9
If I remove everything except the last line I get the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] You do not have the necessary permissions to use the '(unknown)' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
/fporiginal/categories.asp, line 15
Any help gratefully received
Cheers
Ossie
