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 <[email protected]> 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:[email protected]] On Behalf Of Ted Roche > Sent: 14 July 2017 13:57 > To: [email protected] > Subject: Re: VFP OLEDB in M$SQL Linked Server > > On Fri, Jul 14, 2017 at 8:34 AM, Dave Crozier <[email protected]> > 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] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYKgniMM5Vg4kT8W_S-QcQU2fa_Cp0CYikH=smsz5gb...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
