(Keep in mind I was looking at the MySQL part in that URL...search for
whatever you'd like)
On 1/5/2022 6:33 PM, MB Software Solutions, LLC wrote:
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-boun...@leafe.com<mailto:profoxtech-boun...@leafe.com>>
On Behalf Of kbe...@mchsi.com<mailto:kbe...@mchsi.com>
Sent: Wednesday, January 5, 2022 5:39 PM
To: profoxt...@leafe.com<mailto:profoxt...@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" <rk...@invaluable.com<mailto:rk...@invaluable.com>>
To: "ProFox Email List" <profox@leafe.com<mailto: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-boun...@leafe.com<mailto:profoxtech-boun...@leafe.com>>
On Behalf Of kbe...@mchsi.com<mailto:kbe...@mchsi.com>
Sent: Tuesday, January 4, 2022 8:48 PM
To: profoxt...@leafe.com<mailto:profoxt...@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]
_______________________________________________
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/af9d80df-23a0-c657-869f-de184ac5b...@mbsoftwaresolutions.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.