As alan says, there has been a complete about turn on ODBC by Microsoft who originally regarded it as the spawn of the devil but now agree that maybe the rest of the world does have a point.
I use ODBC with no problems apart from the fact as mentioned that there are no 64 bit drivers which is just an irritation as if you do anything using c# in visual studio you have to remember to compile the application as x86 and not x64 or it just bombs. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Alan Bourke Sent: 22 June 2015 15:24 To: [email protected]; [email protected] Subject: Re: VFP Migration to MS SQL & a Difficult Screen... On Mon, 22 Jun 2015, at 02:22 PM, Kurt Wendt wrote: > I'm not sure if it's the same issue w/ODBC - ODBC is now the only method of talking to MS SQL Server that supposedly will be maintained going forwards, because of cross-platform standards. http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with-odbc-for-native-relational-data-access.aspx There should not be an problem with any connecting to either 32-bit or 64-bit SQL Server with 32-bit or 64-bit processes under 32-bit or 64-bit Windows via ODBC. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [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/[email protected] ** 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.
