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. _______________________________________________ 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/mn2pr10mb3407b1aad7a0045ba671e18bd2...@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.
