//flex table opened by JP

Click to See Complete Forum and Search --> : Error on OBDC when renaming Access db


LuisRivera
06-25-2001, 09:42 AM
When i rename an access db and access the website, it generates a DSN connection error (which is correct), but when i rename the db to the correct DSN the website cannot then access the database and throws up the below error.

Technical Information (for support personnel)

Error Type:
Provider (0x80004005)
Unspecified error


I can get it to work by accessing another site on the same server which connects to its own db. This seems to then restart the connection.

Does anyone know the reason for this.

U-96
06-28-2001, 06:14 AM
check MS support for that error, its a real common one which normally means that data source couldn't be connected for one reason or another - usually the wrong name/path or it is in use by another user etc...

I have also found that often changes to the System DNS (assuming you mean changing the stuff in Control Panel->ODBC Data sources) and IIS required a reboot to fix.
You may also need to check the renamed db carried over the folder/share and IIS permissions necessary for the Internet User account (or whoever) to read/execute whatever you had in mind. If you have inserted a new file to replace your previous one, the permissions may not have propagated to it.