May 15, 2024 at 3:07 am
No comments about the SQL version. The application is very old doesn’t support newer version.
Trying to connect to SQL server 2000 using DSN from Windows 11.
Below is the error & the driver installed. Could you please suggest what driver can be installed to solve the connectivity issue? Tried with sqlnative client 11 but didn’t work. No changes can’t be done on SQL server.
SQL Server Error: 772
(Microsoft)|ODBC SQL Server
Driver][DBNETLIB)ConnectionOpen (SECDoClientHandshake0).
Connection failed:
SQLState: '08001'
SOL Server Error: 18
(Microsoft)[ODBC SQl Server Driver(DBNETLIB) SSL Security
Slow is the Installed driver from odbc
SQL Server 10.00.22621.3447 Microsoft Corporation SQLSRV32.DLL
May 15, 2024 at 7:05 am
(Microsoft)[ODBC SQl Server Driver(DBNETLIB) SSL Security
It looks as thought you are trying to establish a secure connection. If using SQL Server authentication, this might just be to send the password. I would:
May 15, 2024 at 7:14 am
ps. You might also want to look at a wire proxy like Gallium Data. It might be possible to put the database on a supported version of SQL Server and point the application at the proxy. The proxy could then be made to translate any old style SQL and pass the result onto the database.
May 15, 2024 at 9:08 am
You need to specify to support unsecured connections 🙁
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 15, 2024 at 11:41 am
Tried using both windows authentication & sql login. Getting similar error with both.
May 15, 2024 at 7:41 pm
In your connection string - make sure you include the Encrypt option and/or pass in the option to trust the server certificate. The newer drivers default this to true - so the connection is attempting to create a secure connection.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply