A heads up on calling code via a linked server.
You may have to do a call via OpenQuery
Select * from OpenQuery( VFPOLE, ' Select * from ' [SERVER_Name].VFPDatabase.Table where bla bla bla ' )
Or you may have to just use [ ] brackets around your server name and not do an OpenQuery() call.
It
On Fri, Jul 14, 2017 at 8:09 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
Thanks Ted.
From a couple of posts I have found they recommend setting up a 32 bit
server, linking this to the VFP tables as a linked server then linking from the 64 bit server back to the 32 bit linked VFP server.... Definitely not a job to do on a Friday, it can wait until I feel somewhat fresher and up for a challenge on Monday!!
Life is never easy!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: 14 July 2017 13:57 To: profox@leafe.com Subject: Re: VFP OLEDB in M$SQL Linked Server
On Fri, Jul 14, 2017 at 8:34 AM, Dave Crozier DaveC@flexipol.co.uk wrote: [snip]
I am beginning to wonder if the 64bit SQL Server doesn't want to play
nicely with the VFP OLEDB 32 bit drivers but can't prove it.
This sounds suspicious.
I've run into issues before with 64-bitness not interoperating with 32-bit VFP. I'd dig around the documentation to see if this is supported.
Any ideas before you go home?
Sorry, I'm already home.
[excessive quoting removed by server]