Posted April 25, 201014 yr I have an application that uses an Access DB that I have just migrated from a 32bit Win2003 server to a 64bit Win2008 server. I have a CRUD application I use to access the DB. This all works just fine on the Win2003 server. I have configured the permissions on the folder containing the .mdb file the same as on my Win2003 server. In IIS7 I have also edited the settings for the website to run in a 32-bit application pool. I have a debug.asp page that checks the connection to the DB which shows all is fine on the Win2003 server but I keep getting access errors as below on the Win2008 server. Testing database connection adodb.connection is OK Could not open database object with connection string Error Number= #-2147467259 Error Desc.= [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Testing your table Could not open database Member_tbl Error Number= #3704 Error Desc.= Operation is not allowed when the object is closed. Could NOT modify data in your table Member_tbl, there must be R/W/C rights in the directory where the database is located Error Number= #3704 Error Desc.= Operation is not allowed when the object is closed. I am new to IIS7 so am not sure if there is something more in particular I need to do in order to get this to work in Win2008 as it does in Win2003. I appreciate any help and suggestions. Cheers!
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.