Access Database Application In Windows 2008 64Bit

monk

New member
Joined
Apr 25, 2010
Messages
1
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!
 

Attachments

  • 6421_assigment_02.jpg
    6421_assigment_02.jpg
    20 KB · Views: 6
Back
Top