Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection works from remote PC but not on Server
Message
From
01/11/2022 10:23:46
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Configuration
Title:
Connection works from remote PC but not on Server
Miscellaneous
Thread ID:
01685187
Message ID:
01685187
Views:
34
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
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Next
Reply
Map
View

Click here to load this message in the networking platform