Friday, February 24, 2012

64 bit Implementation, and Linked Server to Access DB

Can anyone suggest a method to connect to an Access DB from 64 bit
implementation of Yukon ?
Regardless of whether I use Linked Servers or Opendatasource I get the
following error:
"The OLE DB provider "MICROSOFT.JET.OLEDB.4.0" has not been
registered."
If there isn't a 64 bit driver available ..what alternative mechanisms
are available to load data from Access ?
TIAThere is unfortunately no 64-bit version of Jet. You'll need to use a
32-bit version to move your data.
Conor
"MJKulangara" <RutgersDBA@.gmail.com> wrote in message
news:1151430037.910336.142450@.x69g2000cwx.googlegroups.com...
> Can anyone suggest a method to connect to an Access DB from 64 bit
> implementation of Yukon ?
> Regardless of whether I use Linked Servers or Opendatasource I get the
> following error:
> "The OLE DB provider "MICROSOFT.JET.OLEDB.4.0" has not been
> registered."
> If there isn't a 64 bit driver available ..what alternative mechanisms
> are available to load data from Access ?
> TIA
>|||There is unfortunately no 64-bit version of Jet. You'll need to use a
32-bit version to move your data.
Conor
"MJKulangara" <RutgersDBA@.gmail.com> wrote in message
news:1151430037.910336.142450@.x69g2000cwx.googlegroups.com...
> Can anyone suggest a method to connect to an Access DB from 64 bit
> implementation of Yukon ?
> Regardless of whether I use Linked Servers or Opendatasource I get the
> following error:
> "The OLE DB provider "MICROSOFT.JET.OLEDB.4.0" has not been
> registered."
> If there isn't a 64 bit driver available ..what alternative mechanisms
> are available to load data from Access ?
> TIA
>

No comments:

Post a Comment