Hi,

I had a system on my personal computer that I had few ASP applications hosted to make my life easier but now that I upgraded the system to Windows XP with Office 2003, the ASP code is no longer connecting to my old database.

Here is the error I get:

Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/includes/utils.asp, line 10


Here is the code that I use:

Set Conn=server.createobject("adodb.connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & DbName & ";"
Conn.Open

Please help me sort this out. Why is it not connecting with a new system? The local site worked fine before I upgraded the system.

Is this not supported on Windows XP with office 2003?

If not, could you please provide me with a code on how I could connect to an Access database on this system.


Thank you.

what was the old system?

have you recreated the DSN?

My old system was Windows XP with Office 98 (older version). How do I create a DSN?

Thank you.

take a look at http://www.webmaster-talk.com/the-da...ss-string.html for the connection string syntax.

the ODBC AND OLE drivers will have been upgraded

For connection string syntax, try this link as well http://www.connectionstrings.com This web site is highly recommened.

Netclick: IF you're running XP 64-bit edition (as I am), you will have to convert IIS to 32-bit compatibility mode since there are no 64-bit Jet drivers (why, I don't know, but it's true.)

http://support.microsoft.com/?id=894435

You'll need the first line in this article, but not the second.