Richard makes me think of the connection string OPTIONS value....there are certain flags to set to allow you to get memo fields in certain sizes, iirc. Something to investigate. I went to https://www.connectionstrings.com/mysql/ to investigate but didn't see where the exhaustive list of flags are for that OPTION= part of the sqlstringconnect value.
--Michael
On 1/5/2022 6:30 PM, Richard Kaye wrote:
Not trying to be obnoxious here but installing a driver on its own won’t change anything. 😊
Has the connection string for the application been changed to use 17?
I don’t think there is an “ODBC Driver 11 for SQL Server” but I could be wrong. There’s definitely a 13 and a 17. There is also “SQL Server Native Client 11.0”.
Is it possible to use ODBC Manager in the environment in question to create a connection to the SQL Server the EXE uses? If that works, then you know the problem lies in the application configuration.
--
rk
From: ProfoxTech <profoxtech-bounces@leafe.commailto:profoxtech-bounces@leafe.com> On Behalf Of kbelan@mchsi.commailto:kbelan@mchsi.com Sent: Wednesday, January 5, 2022 5:39 PM To: profoxtech@leafe.commailto:profoxtech@leafe.com Subject: Re: VFP9 and SQL memo fields
I am pretty sure we are using Microsoft ODBC Driver 11 for SQL Server
I think they tried to install ODBC Driver 17 and had the same results
----- Original Message ----- From: "Richard Kaye" <rkaye@invaluable.commailto:rkaye@invaluable.com> To: "ProFox Email List" <profox@leafe.commailto:profox@leafe.com> Sent: Wednesday, January 5, 2022 8:43:26 AM Subject: RE: VFP9 and SQL memo fields
Do you know what SQL driver your EXE is currently using?
--
rk
From: ProfoxTech <profoxtech-bounces@leafe.commailto:profoxtech-bounces@leafe.com> On Behalf Of kbelan@mchsi.commailto:kbelan@mchsi.com Sent: Tuesday, January 4, 2022 8:48 PM To: profoxtech@leafe.commailto:profoxtech@leafe.com Subject: Re: VFP9 and SQL memo fields
Yes it is a compiled EXE for a legacy app that has been running great for years.
I am using West-Wind wwSQL class to execute Queries and Stored procedures. I don't think it is remote views.
I call the method and it returns a cursor or an oData object.
I hope that helps as I am not an SQL expert.
[excessive quoting removed by server]