Heloo everyone
I Have simple question - related to:
http://zeos.firmos.at/viewtopic.php?t=1262
and
http://zeos.firmos.at/viewtopic.php?t=275
(ZPlainDbLibMsSql7.pas)
- what's with
libsybdb.so
??
I have downloaded and instaled FreeTDS 0.64 and there is:
libsybdb.so.5
but no libsybdb.so
Is it the same ??
whell - if not where can I find
libsybdb.so
??
Any sugestions Plz.
Connecting MSsql from Linux - libsybdb.so - problem
Moderators: gto, cipto_kh, EgonHugeist
I was able to connect to MSSQL server 2000 with Zeos over Lazarus:
- First of all, for FreeTDS you have to be sure that the server is listening TCP/IP on port 1433 (o whatever you defined), you can test it with command netstat -an on the server prompt.
- Windows client Native: You can use TZConnection with protocol mssql, in this case, you must have the client library ntwdblib.dll installed or alongside your exe. This dll works with both Named Pipes and TCP/IP connections. For Delphi (not Lazarus) it appears to be another protocol ado to be used with SQL server 2005 or later. However, note that using source code with protocol mssql or ado is not platform independient.
- Windows client FreeTDS: You can use TZConnection with protocol FreeTDS_MsSQL-2000, in this case you must put msdblibd.dll in the same folder of your exe. This dll is supplied in the lib folder of Zeos, with 32 and 64 bit versions. There is only support for TCP/IP fixed port connections (no Named Pipes or dynamic ports). Also, there are other three protocol variants for different server versions.
- Wine on Linux client: Only the FreeTDS protocols and dll works (and only with TCP/IP on fixed port, no Named Pipes in Wine, no Named Pipes in FreeTDS).
- Linux Client: You can use TZConnection with protocol FreeTDS_MsSQL-2000, in this case you must have installed the FreeTDS libraries (for example in Debian the packages freetds-bin and libsybd5). For this to work you have to modify ZPlainDbLibDriver.pas in th line 68: FREETDS_LINUX_DLL_LOCATION = 'libsybdb.so';
- First of all, for FreeTDS you have to be sure that the server is listening TCP/IP on port 1433 (o whatever you defined), you can test it with command netstat -an on the server prompt.
- Windows client Native: You can use TZConnection with protocol mssql, in this case, you must have the client library ntwdblib.dll installed or alongside your exe. This dll works with both Named Pipes and TCP/IP connections. For Delphi (not Lazarus) it appears to be another protocol ado to be used with SQL server 2005 or later. However, note that using source code with protocol mssql or ado is not platform independient.
- Windows client FreeTDS: You can use TZConnection with protocol FreeTDS_MsSQL-2000, in this case you must put msdblibd.dll in the same folder of your exe. This dll is supplied in the lib folder of Zeos, with 32 and 64 bit versions. There is only support for TCP/IP fixed port connections (no Named Pipes or dynamic ports). Also, there are other three protocol variants for different server versions.
- Wine on Linux client: Only the FreeTDS protocols and dll works (and only with TCP/IP on fixed port, no Named Pipes in Wine, no Named Pipes in FreeTDS).
- Linux Client: You can use TZConnection with protocol FreeTDS_MsSQL-2000, in this case you must have installed the FreeTDS libraries (for example in Debian the packages freetds-bin and libsybd5). For this to work you have to modify ZPlainDbLibDriver.pas in th line 68: FREETDS_LINUX_DLL_LOCATION = 'libsybdb.so';
Re: Connecting MSsql from Linux - libsybdb.so - problem
Thak you! I connected to SQL2008 using this:
- Linux Client: You can use TZConnection with protocol FreeTDS_MsSQL-2000, in this case you must have installed the FreeTDS libraries (for example in Debian the packages freetds-bin and libsybd5). For this to work you have to modify ZPlainDbLibDriver.pas in th line 68: FREETDS_LINUX_DLL_LOCATION = 'libsybdb.so';