missing odbc driver

[Guest MarketUS]

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.

[Guest Steve Foster [SBS MVP]]

Re: missing odbc driver

 

MarketUS wrote:

>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.

 

--

Steve Foster [sBS MVP]

---------------------------------------

MVPs do not work for Microsoft. Please reply only to the newsgroups.

[Guest MarketUS]

Re: missing odbc driver

 

 

 

"Steve Foster [sBS MVP]" wrote:

> MarketUS wrote:

>

> >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.

>

> --

> Steve Foster [sBS MVP]

> ---------------------------------------

> MVPs do not work for Microsoft. Please reply only to the newsgroups.

>

 

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.