Using Access database on a 64-bit hosting environment Print

2

When connecting to an Access database on an IIS server where the site's worker process runs as 64-bit, the 32-bit JET driver will not function:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\access.mdb

Your connection string will need to be updated to use the 64-bit ACE driver:

Provider=Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;Data Source=C:\path\to\access.mdb

Was this answer helpful?

Related Articles

Redirect non-SSL to SSL in Windows (IIS) The following code sample will 301-redirect http://www.domainname.com to... How do I redirect my site using a .htaccess file? Note: Applies to Linux hosting accounts only. Create an empty text file using a text editor such... Enable custom error pages on IIS 7 (Windows 2008) and newer Custom error pages can be implemented in IIS 7 (Windows 2008) and newer by placing a web.config... Remotely view error messages on IIS 7 (Windows 2008) and newer When a website page encounters a coding error on a IIS 7 (Windows 2008) or newer hosting server,... Create T-SQL dump of MS SQL data Open Management Studio and connect via your SQL server host name, the database username and...

« Back