Hi,
got a strange one at a client's site today.
SQL Server 2016 installed on a Windows Server 2016.
My VFP app was successfully connecting using SQL Server Native Client 10.
The client turned off TLS 1.0 and 1.0 on the server and then my VFP app stopped connecting.
We uninstalled Native Client 10.
I changed the connection string to use SQL Native Client 11.0 and {ODBC Driver 17 for SQL Server} and got this error:
"Connectivity error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
I am able to connect using the ODBC applet on the server with both of these drivers.
I am able to connect from a workstation using both those drivers.
I have no idea what could be causing this so would appreciate any suggestions