Environment versions
Network:
Windows 2008 Server
>>>>The latest SQL Server ODBC driver, which works for SQL 2014 and all prior versions, is ODBC Driver 11 for SQL Server. There is an x64 version that must be used on x64 OS versions, and installs both the 32-bit and x64 versions. Then there's an x86 version, that installs just the 32-bit version. VFP, of course, needs the 32-bit version, whether on an x64 or x32 OS version.
>>>>
>>>
>>>Thanks, but I'm really looking more for the list of which SQL ODBC drivers work correctly with VFP. I know for sure one of the later versions mangles memo fields in VFP, and I'm looking to avoid discovering these incompatibilities myself.
>>
>>We use 11 in production for perhaps 120 users. We use memo fields extensively, and there are no reported issues.
>
>This version seems to have to the memo issue - varchar(max) doesn't come down as a memo field. Switching to something like varchar(6000) works, but really sucks.
We're having no problem with memofields, against sql 2005 and 2012. That probably because we are using remote views, and are specifying the conversion in the remote view properties.
Hank
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only