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!
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!