Can't connect to the local SQL server using ODBC, SQL SERVER ERROR 18

Questions about Wine on Linux
Locked
ryangosling1337
Newbie
Newbie
Posts: 1
Joined: Sat May 27, 2023 6:46 am

Can't connect to the local SQL server using ODBC, SQL SERVER ERROR 18

Post by ryangosling1337 »

Hello everyone,
i am using one of the Linux Debian distribution kit, where i installed wine.8-9, winetricks with odbc support and sql server. SQL server is working, the output of the command

Code: Select all

systemctl status mssql-server.service
is active. Then using command

Code: Select all

wine control
, i enter to the Data sources, adding SQL server with localhost and i ve gogt the error
"SQL SERVER ERROR 18".
there is one way how to resolve this issue:
https://www.sqlnethub.com/blog/dbnetlib ... r-resolve/
SQL Server still supports all TLS protocols, currently from 1.0 to 1.2. However, depending on the version of SQL Server you have, especially in cases of older SQL Server versions, you might need a patch.
But the thing is i don't want to transfer to TLS 1.0. So i want to find another solution using open source code of wine. Is that possible to enable support of TLS 1.2 in the code?
Or is there is a solution to change some functions in wine to make SQL server work?
Also i ve used winedebug=+all, and filtered logs where there was attempt to connect

Code: Select all

5247.252:0120:0124:trace:nls:MultiByteToWideChar cp 0 "ConnectionOpen (SECDoClientHandshake()).\x00" -> L"ConnectionOpen (SECDoClientHandshake()).\0000", ret = 41
5247.252:0120:0124:Ret  KERNEL32.MultiByteToWideChar() retval=00000029 ret=74cb18f8
5247.252:0120:0124:RET  DBnetlib.ConnectionOpenW() retval=00000000 ret=1f9dc25f
5247.252:0120:0124:Call KERNEL32.GetTickCount() ret=1f9dc217
5247.252:0120:0124:Ret  KERNEL32.GetTickCount() retval=00501114 ret=1f9dc217
5247.252:0120:0124:CALL DBnetlib.ConnectionErrorW(01bd7298,0062aa44,0062a80c,0062a810) ret=1fa12a51
5247.252:0120:0124:RET  DBnetlib.ConnectionErrorW() retval=00000001 ret=1fa12a51
Locked