Can Data Services on 64-bit machine access a 32-bit driver?

dataservices administration
1

Hi

I need to connect to a FoxPro database using a 32-bit ODBC connection from Data Services 14.2.6.

I have created a “System DSN” entry using the “ODBC Data Source Administrator (32-bit)” found in the folder: C:\Windows\SysWOW64.
I gather this means that from my 64-bit server I have created a 32-bit FoxPro driver connection.

The problem I have is that from Data Services, when creating the Datastore I cannot see the new ODBC data source connection I created.

Is it unachievable for the 64-bit Data Services application to access the FoxPro 32-bit driver?

Many thanks for any help.

poppy (BOB member since 2014-10-13)

2

Data Service is 64-bit application, and it can’t use 32-bit DB Driver with it, you will need 64-bit driver

if 64-bit FoxPro driver is not available and you are only reading data from FoxPro then try using JDBC Adapter instead, you will need the JDBC Driver for FoxPro

manoj_d (BOB member since 2009-01-02)