Database connection issues

This is a very different issue to the original issue posted.

The error is due to the incorrect name or IP address to the database server. Contact your web host for the new SQL Server Hostname or IP address.

You should then reinstall the latest release and when the install wizard asks for the database connection details put in the new hostname or IP supplied by your hosting company.

Microsoft are not making a 64 bit Access driver, which is why you have this issue.

What you need to do is go into the IIS Manager and locate the Application Pool for the website that you wish to use Access on. You then need to edit the application pool using the advanced option and set the application pool to run in 32 bit mode.

Once the application pool is running in 32 bit mode you will be able to use the Access JET 32 bit driver which comes with Windows 2008.

Microsoft actually recommend that you run application pools in 32 bit mode as they say that not only do you get better compatibility with 32 bit drivers, components, etc. but also it gives better memory usage and performance, so you may want to change the default application pool settings to always use 32 bit mode.


Edited by WebWiz-Bruce - 28 December 2009 at 9:50am