El 21/05/13 11:32, Frank Cazabon escribió:
I use SQL Server 2008 and 2012 data in my VFP applications. I
normally use SQL Server Native Client as my ODBC connection. My
connection string is normally like this:
DRIVER=SQL Server Native Client
10.0;UID=user;PWD=password;DATABASE=BPO;SERVER=(local)
Frank.
Frank Cazabon
On 21/05/2013 10:18 AM, MB Software Solutions, LLC wrote:
Friend of mine asking about any gotchas with VFP and SQL Server 2012
access via ODBC connection. I don't think there are but wanted to
fire a question Q out to the list on that. Anyone successfully
accessing SQL Server 2012 from VFP ODBC connection?
tia,
--Mike
I've also been using it in my previous job with no problems at all.
Well, that's not entirely true. There have been some queries that did
receive a truncated answer, so you should check the quantity of tuples
received to be sure. In those cases I simply changed the query to some
other form that brought the same set or divided it into a couple of
queries and combined them within VFP. Never found out what was going on,
but OTOH I was only allowed to use VFP6 and the people maintaining the
database were not the best. So it might have something to do with
database settings or maybe is something particular to VFP6 and corrected
in newer releases.
_______________________________________________
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.
