Microsoft Visual FoxPro is a powerful object-oriented environment for database construction and application development. The Microsoft Visual FoxPro ODBC Driver enables applications to open, query, and update data in Visual FoxPro and earlier versions of FoxPro through the Open Database Connectivity (ODBC) interface. ODBC Driver for xBase Compatibility xBase Compatibility ODBC Driver for xBase supports: FoxPro 2, Visual FoxPro; dBaseIII-dBase10; Codebase, Clipper; and other DBF file formats; Supported Target Platforms Windows, 32-bit and 64-bit (including Windows Terminal Server) macOS, 32-bit and 64-bit.

• Ms Sql X64 Odbc 32 Foxpro Tutorial

What I have:

• a 64-bit SQL Server 2012 installed on Windows Server 2008R2
• 32-bit ODBC driver SyBase ASE 12.5.1 (and I have no ability to obtain any other official driver)

What I need:

• access from SQL Server to SyBase Adaptive Server Enterprise/12.5.4/EBF 14921 ESD#7/P/RS6000/AIX 5.1/ase1254/2095/64-bit/FBO/Fri Oct 12 12:11:32 2007 (I need to select data from 2 tables and to execute 2 stored procedures)

I've installed the ODBC driver and created an ODBC source using c:WindowsSysWOW64odbcad32.exe. A connection is successfully established when I test it from ODBC Data Source Administrator. But when I create a linked server I get an error:

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'.

That's because there is a mismatch between 64-bit SQL Server and 32-bit ODBC driver.And obviously I need some proxy to provide connection between server and driver.I've found a few bridges but all of them are proprietary.

Is there any free proxy solution or a free 64-bit SyBase driver?

Among the follow mates, iSkysoft Phone transfer is something worth the absolute attention.Being the full-fledged software for the file transfer, they are cross platform friendly. If you went with the traditional method of transferring the files, it wouldn’t be a feasible option like having a dedicated software to do that. Iskysoft phone transfer with crack windows.

UPD

There is still no good production solution, but as proposed Paolo in the answer, I use a 32-bit SQL Server Express to resolve the issue.

What I've done step by step:

Ms Sql X64 Odbc 32 Foxpro Tutorial

1. install a 32-bit SQL Server Express 2014 on the samecopmputer (probably it is not the best idea, but it makes possibleto use Shared Memory )

2. connect the 32-bit SQL Server Express to the Sybase database via ODBC

3. create stored procedures on Express using the OPENQUERY function to request data from SyBase

4. connect the 32-bit SQL Server Express 2014 to the 64-bit SQL Sever 2012 as a linked server (address of Express is LOCAL(SQLEXPRESS))

1 Answer

install a spare sql server express 32 bit (i would put it on a separate machine) as a bridge to sybase.

on the 64bit instance create a linked server to the 32bit instance; on the 32bit instance create a linked server to sybase.

i didn't try this double hop configuration but it may eventually require some view on the 32bit rdbms to access the data on sybase from the 64bit instance.

it is not a solution i would like to have in production for a long time..

Not the answer you're looking for? Browse other questions tagged sql-serverodbcsybase32bit-64bitlinked-server or ask your own question.