SQL server, linked server, FoxPro

I've installed the Microsoft OLE DB Provider for Visual FoxPro 9.0.   However, when I try to setup a linked server, it does not appear in the list.   Anyone ever done this?  Any ideas on why it's missing from the list? DataSources.png
LVL 1
HLRosenbergerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
I believe this is because you're trying to use it on 64bit SQL Server and please see link below for more details - there's some workaround but you may be out of luck to link them directly.
https://social.msdn.microsoft.com/Forums/en-US/d172f7de-78f9-4edd-aed8-fd43098dd17b/provider-not-listed-in-linked-servers-providers-visual-foxpro-ole-db

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ad87945a-b47f-4ec5-941a-d2ec7b02be59/import-vfp-tables-in-sql-server-2008-r2

"
There is no 64-bit VFP OleDB provider. That is why we can’t import data from VFP to a 64-bit SQL Server. The workaround in the link you provided won’t work too, as it is using the VFP provider too. This can’t work in 64bit SQL Server.

In order to work around the issue, we can firstly install a 32-bit SQL Server, import the data from VFP to this 32-bit SQL Server, and then synchronize the data from the 32-bit SQL Server to the 64-bit SQL Server. This workaround is available too in other scenarios that there is no 64-bit provider and we are using 64-bit SQL Server.
"

Alternatively if you must create a SQL linked server would be to download,install and to create a ODBC data source and use that data source in your SQL to create a linked SQL Server to your VFP database(s) table(s).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check if it appears in ODBC (both versions: 32bit and 64bit)
HLRosenbergerAuthor Commented:
Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.