Access XP and Windows XP 64-bit

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

How about trying an mdac reinstall:

http://www.microsoft.com/downloads/d...7-185d0506396c

-t

SEFL ha scritto:

Thanks, dude. But no luck. Same error.

tommaso.gastaldi@uniroma1.it wrote:

Hmmm...

Dont' know if this is the right directionto look, but there seems that
a 64bit version of MDAC 2.8 exists included in Windows 2003 (xp does
not seem to mentioned), check out for instance:

http://paulfallon.com/2004/08/16/MDA...t+Windows.aspx

-t

SEFL ha scritto:

Unfortunately, they're referring to Windows Server 2003 so that doesn't
work either. :(

tommaso.gastaldi@uniroma1.it wrote:

A few more places where to take a look:

http://msdn.microsoft.com/library/de...nstall.asp?fra

http://msdn.microsoft.com/library/de...dacroadmap.asp

Jet 4.0 Service Pack 8
http://download.microsoft.com/downlo...58-x86-enu.exe

hope you have some luck (let me know how you solve it).

-tom

SEFL ha scritto:

I don't think there is a 64 bit Access ODBC driver, for
use with 64 bit ODBC. I think you would have to uninstall
64 bit ODBC, and install a copy of 32 bit ODBC. 16 bit
ODBC was a bit simpler, because it could co-exist with
32 bit ODBC, but I don't think that's true for 64 and 32.
Also, ODBC comes with windows now, so there is not a
separate install for 32 bit ODBC, but I think I saw an
article about how to copy it from Win 32?

(david)

"SEFL" <adam@searchenginefriendlylayouts.comwrote in message
news:1153165441.950634.325870@s13g2000cwa.googlegr oups.com...