Can you provide some more context, Kent? Compiled EXE? Ad-hoc queries via SQL pass-through? Remove views?
--
rk
From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of kbelan@mchsi.com Sent: Tuesday, January 4, 2022 4:54 PM To: profoxtech@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 ---