0

I have a Foxpro database that I must query from a 64 bit SQL server. I can't link it directly, so I installed a 32 bit SQL server and linked Foxpro correctly. Then I linked the 64 bit server with the 32 bit SQL server.

Now, how can I query the linked 32 bit server from the 64 bit SQL server?

bassim
  • 886
  • 1
  • 21
  • 33
Massimiliano Oreto
  • 57
  • 10
  • So you can't get a 64 bit Foxpro driver? Do you need to query the Foxpro data in real time using a linked server? Or can you just schedule a frequent dataload into a staging table in SQL Server (using 32 bit SSIS)? This will make it way easier and more reliable to query, the data just won't as up to date. – Nick.Mc Feb 06 '15 at 10:09
  • I know ther isn't a 64 bit Foxpro driver. I must query the server Real Time but your second solution could be acceptable for a "end day" statistics. – Massimiliano Oreto Feb 06 '15 at 10:54
  • I don't really recommend doing it but you could define your linked server on your 32 bit server, create a view around it, then reference that view from your 64 bit server via a linked server – Nick.Mc Feb 06 '15 at 11:36
  • Thank you for information. I follow this solution but the performance are not so good :) Other chance? – Massimiliano Oreto Feb 06 '15 at 13:23
  • Not only is the performance bad, it will be unreliable. There's no other way I'm aware of for adhoc queries. You need to consider whether these really need to be adhoc or whether you can replication the FoxPro data into SQL Server on a regular basis (i.e. every 10 minutes) – Nick.Mc Feb 07 '15 at 23:13

0 Answers0