missing odbc driver

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarketUS - 31 Dec 2007 01:43 GMT

I only show sql driver in dsn. I have office 2007 installed and there is no
access driver. I get the message... please reinstall the driver

Does anyone know the solution?

Thanks.

Reply to this Message

Steve Foster [SBS MVP] - 31 Dec 2007 10:04 GMT

>I only show sql driver in dsn. I have office 2007 installed and there is
>no
>access driver. I get the message... please reinstall the driver
>
>Does anyone know the solution?

There are no 64-bit ODBC drivers for Office, only 32-bit ones.

You need to run the 32-bit ODBC Administrator (in the SYSWOW64 folder) to
manage 32-bit ODBC settings, where you _will_ find the usual Office driver
selection.

Signature

Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

Reply to this Message

MarketUS - 31 Dec 2007 14:08 GMT

> >I only show sql driver in dsn. I have office 2007 installed and there is
> >no
[quoted text clipped - 7 lines]
> manage 32-bit ODBC settings, where you _will_ find the usual Office driver
> selection.

Thanks Steve, I keep forgetting there are two of everything. I used the
control panel version which is 64. I now have a shortcut. Maybe one day it
will all merge.

Reply to this Message