When I connect to my Microsoft Access database, I receive the error message catastrophic failure.

Symptoms

I receive an error similar to the following:

Provider error '8000ffff'

Catastrophic failure

 

Cause

This is caused when connecting to a Microsoft Access database using a connection string containing "Driver="{Microsoft Access Driver (*.mdb)}". This driver is out-dated and should not be used with the latest version of Microsoft's MDAC which is installed on all web servers.

Resolution

Use the following DSN-less connection string for your Microsoft Access connections instead of the Microsoft Access ODBC driver:

For Microsoft Access Databases:

ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\inetpub\xxx\_private\myaccessfile.mdb"

Note that there is a space between "Data" and "Source". This parameter should be specified as "Data Source=".

  • 4 Users Found This Useful
Was this answer helpful?

Related Articles

Where can I find documentation for ServerObject's AspMail component?

This documentation can be found at: http://www.serverobjects.com/products.html For...

How do I upload files through my web pages?

You can use Software Artisan's SAFileUP. This is an ASP component that allows you to upload files...

What is PageCounter and how do I use it?

About Page Counter PageCounter is an object that counts and displays the number of times a Web...

How do I setup Microsoft Outlook Express to read my e-mail?

Follow these steps: Open Microsoft Outlook Express. From the Tools menu, click...

How do I setup Netscape Messenger to read my e-mail?

Follow these steps: Open Netscape Navigator. Click the Edit menu and then click Preferences......