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 11:17:55
 
 
To
01/11/2022 10:23:46
General information
Forum:
Microsoft SQL Server
Category:
Configuration
Miscellaneous
Thread ID:
01685187
Message ID:
01685188
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

Check if you have these ODBC drivers installed ODBC 32 bit.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform