Added: March/23/2007 at 3:33pm | IP Logged

Chris: 

I had ASPProtect v7 installed and everything worked great. Then my Server decided to basically go out of business, so I moved to a new Server. I am having connection access problems and my customers are unhappy!

1. I am using a DSN-Less Connection with MSAccess. All permissions (r/w/x/d) are set on the new server from the directory level:

2. I have corrected the Connection String to point to the new server as follows (It is not one “generated” by ASPProtect):

ConnectionString = "DBQ=D:\wwwroot\vspa\data\database\aspprotect_access2003.mdb ;Driver={Microsoft Access Driver (*.mdb)};UID=don poss;Password=temp"

DatabaseType = "MSACCESS"

3. Nevertheless, I get the dreaded error message:

“[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x17dc Thread 0x17b8 DBC 0x89e4cdc Jet'.
“This means there is most likely a problem with the "ConnectionString" info that you specified.
If you are using a DSN-Less Connection with MSACCESS.
Check that the physical path to the database has been specified correctly.
It has to be perfect and correct. It cannot be specified using "http://" or by using "server.mappath".
It has to be specified like the following example.
ConnectionString = "DBQ=C:\Inetpub\wwwroot\advpass_pro\_database\passwords.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=admin;PASSWORD=Xpass"

Please advise as soon as possible.

Thanks,

Don Poss