Page 1 of 1

Failed to connect to mssql

Posted: 29.11.2022, 16:10
by zhuyl
testing environment:zeoslib-code-0-r7936-trunk,lazarus, freeTDS1.3

Re: Failed to connect to mssql

Posted: 29.11.2022, 16:50
by marsupilami
Hello zhyul,

some more information is required:
- what error do you get?
- what is the server name you use?
- do you use freetds on Linux or Windows?
- do you use some special settings?
- did you - by chance - forget to activate TCP/IP connections on your SQL Server?
- which exact version of freetds do you use?
- which version of Lazarus and FPC do you use?

On our servers freetds connects correctly to MS SQL Server. Also I suggest to use the 8.0-patches branch.

With best regards,

Jan

Re: Failed to connect to mssql

Posted: 30.11.2022, 02:11
by zhuyl
Thank you, Jan
With your reminder, the problem was solved. Because mssql does not have a patch installed, tcp/ip cannot be used.