Can you provide some more context, Kent? Compiled EXE? Ad-hoc queries via SQL pass-through? Remove views?
-- rk From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of kbe...@mchsi.com Sent: Tuesday, January 4, 2022 4:54 PM To: profoxt...@leafe.com Subject: VFP9 and SQL memo fields Happy New Year !! I have a client trying to upgrade their SQL 2012 server to 2016 but we are having a problem with the TEXT data type only returning 400 characters. We tried to change to VARCHAR(Max) but that returns the same 400 character limit. I am not an SQL expert so I am not sure what is causing the problem, but I suspect it is the ODBC driver we are using?? Has anyone had this problem and found a solution or a new updated ODBC driver that works with SQL 2016? Thanks, Kent --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/mn2pr10mb34077f8de649a32cfbd80774d2...@mn2pr10mb3407.namprd10.prod.outlook.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.
