Connecting MSsql from Linux - libsybdb.so - problem

Forum related to MS SQL Server

Moderators: gto, cipto_kh, EgonHugeist

noel
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 28.09.2007, 09:30

Connecting MSsql from Linux - libsybdb.so - problem

Postby noel » 02.10.2007, 18:05

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.

noel
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 28.09.2007, 09:30

Postby noel » 04.10.2007, 19:58

OK
I made some changes.
I have installed a FreeTDS rpm, but not for my RH distribution, but marked as other,
and there is libsybdb.so.

But Still not working

When I'm trying to connect (to mssql server) I have a messagebox "ACCESS VIOLATION"

What might be the problem ??

stootch
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 15.11.2007, 08:08

Postby stootch » 15.11.2007, 10:48

Same problem here. Gentoo with updated FreeTDS installed... Anyone?

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 16.11.2007, 19:57

Usually this means the the API structures have changed since the version zeoslib is programmed for. I have no idea what version you should use, however...

Mark

touchring
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 01.07.2009, 19:55

Postby touchring » 21.07.2009, 18:13

Hi, it has been 1 year since, does zeolibs still connect to mssql from linux platform? Thanks.

vansiqq
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 25.07.2010, 12:59
Location: Aracaju/Brazil
Contact:

Postby vansiqq » 25.07.2010, 13:15

Hi all,

Anybody gets a solution for this problem on connect to MSSQL?

Thank you for any ideas.

mario13
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 06.08.2011, 22:27

Postby mario13 » 08.10.2012, 16:54

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';

krzynio8
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 30.03.2014, 10:56

Re: Connecting MSsql from Linux - libsybdb.so - problem

Postby krzynio8 » 03.04.2014, 13:50

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';


Return to “MS SQL Server”

Who is online

Users browsing this forum: No registered users and 1 guest