Re: Access XP and Windows XP 64-bit

How about trying an mdac reinstall:

http://www.microsoft.com/downloads/details.aspx?DisplayLang=en&FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c

-t

SEFL ha scritto:

Hi there,

I'm trying to write a VBS that accesses a local database on my system
(personal project).

I'm running Windows XP 64-bit with Access XP. Every time I try to
access the database on the machine, I get the following error:

"Provider is not specified and there is no designated default
provider."

The code itself is correct because I tried the exact same code on a
Windows 2000 box and it worked fine.

If I go into the ODBC Data Source Administrator, I see three User Data
Sources listed under the User DSN tab, including the MS Access driver.
But if I look under Drivers, I only see the SQL Server driver. In
addition, if I click the "Configure" button after selecting the Access
driver using User DSN, I see the following two errors:

"The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver
could not be found. Please reinstall the driver."

"Component not found in the registry."

So I'm assuming from this that the driver wasn't configured right
somewhere along the way. I just can't seem to find where I'd configure
it.

The really weird thing is that I'm running IIS on the same box, with
development websites running Access databases in some form or fashion,
and they run fine off the OLE Jet driver (which I had to configure for
32-bit compatibility.) So from this, I'm guessing I somehow need to
use some form of 32-bit compatibility for the Access driver itself.
But I don't know where I'm supposed to look.

I guess my question is: where exactly is the MDB ODBC driver, and how
would I install/configure it?

Thanks.



Adam
http://www.searchenginefriendlylayouts.com

.

Quantcast