Access Database Application In Windows 2008 64Bit

[monk]

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!