[solved]Can not connect to Microsoft SQL Server using TMSSQLConnection
lazarus / 16-Databases

----------------------------------------------------------------------
hawkx · 2014-05-27 00:22

I can't connect to my MSSQL server using TMSSQLConnection under linux.

1. SQL Server: MSSQL 2005 64bit
2. Linux: CentOS 6.5 32bit
3. freetds: freetds-0.9.1

I can connect and select data from my MSSQL server using tsql, but
failed to connect to my MSSQL, first, it can not found libsybdb.so,
then I do "ln -s /usr/local/freetds/lib/libsybdb.so /lib/libsybdb.so",
then my got this error message:
An unhandled exception occurred at $080A41AD:
EMSSQLDatabaseError: TMSSQLConnection : Error 20009 :
Unable to connect: Adaptive Server is unavailable or does not exist

I would do what to solve this, please give me some clues, thanks!

by the way: by using same code, I can connect to my MSSQL Server under
windows.

----------------------------------------------------------------------
hawkx · 2014-05-27 00:49

solved by using server name instead of server ip address.