>Dear All
>
>We are trying to establish OLEDDB or ODBC connection to native VFP9 database but can't get
>MSSQL management console to see OLEDB provider.
>
>We installed latest version of VFPOLEDB provider (see link below) installed it on server, but MGM console is just blind to it.
>http://serverfault.com/questions/361226/how-to-successfully-connect-to-foxpro-database-files-using-mssql-linked-server-f
>
>Please note that idea is to access VFP data from MSSQL console rather then other way around.
>If not OLEDB provider than at least some ODBC data source.
>
>MSSQL version is 2014 64bit.
>
>I am sure this should be routinely doable by some of you guys, so what is the catch here ?
>Any ideas ?

To expand on Sergey's point, 64-bit SQL Server can't load 32-bit drivers (ODBC or OLEDB): https://social.msdn.microsoft.com/Forums/sqlserver/en-US/388baa85-64bd-428a-bfc0-7d110a9492e9/connecting-64bit-pervasive-server-to-64bit-sql-server-via-32bit-pervasive-odbc-client-interface?forum=sqldataaccess

Apparently there is a Sybase 64-bit driver for VFP: https://social.msdn.microsoft.com/Forums/en-US/f9654e40-942a-46bb-9b03-e64e7bd97bbc/oledb-64-bit-driver-for-vfp?forum=visualfoxprogeneral

Earlier this month new ODBC drivers were announced here on the UT: https://www.levelextreme.com/ViewPageNewDownload.aspx?ID=38483 . The list doesn't include SQL Server but you could contact them, maybe they have one for that.