FreeTDS_MsSQL>=2005 Connection problem

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Post Reply
Hardy55
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 05.07.2013, 11:33

FreeTDS_MsSQL>=2005 Connection problem

Post by Hardy55 »

Hello @all

Big tanks to all developers for this excellent database-tool!


This is my problem:
-----------------------------------------------------------------
ZEOS Version 7.1.3-stable
on Lazarus #: 1.2.0 ( 32 Bit on 64 Bit Win 7 Prof)
FPC-Version : 2.6.2
SVN-Revision : 44303
-----------------------------------------------------------------
SQLSERVERS in use

S_OLD\INST_2005 TCP/IP at port 3261
LAPTOP\INST_2008R2 TCP/IP at port 1057
S_NEW\INST_2008R2 TCP/IP at port 49195
-----------------------------------------------------------------
Delphi6 and the dbexpress/BDE - Divers - no connection problems!
Lazarus an ZEOS and the old ntwdblib.DLL - no connection problems!
-----------------------------------------------------------------

But !

Hostname : S_OLD\INST_2005 or LAPTOP\INST_2008R2
Lib locatin : C:\DBLIB\32\dblib.dll
Protocol : FreeTDS_MsSQL>=2005

when I try this : connect := TRUE
then the hole LAZ IDE hangs, no err - msg
when I start the program then the same drama

with the sqlserver S_NEW\INST_2008R2 there is no connection problem at all!

Hostname :S_NEW\INST_2008R2
Lib Loc : C:\DBLIB\32\dblib.dll
Protocol : FreeTDS_MsSQL>=2005

Code: Select all

....
       ZConnection1.Connected := False;
       ZConnection1.Protocol  :='FreeTDS_MsSQL>=2005';
       ZConnection1.LibraryLocation :='C:\DBLIB\32\dblib.dll';
       ZConnection1.HostName  :=  DB_Instance;
       ZConnection1.Database  := 'MASTER';
       ZConnection1.User      := 'XXXXXXXX';
       ZConnection1.Password  := 'YYYYYYYY';
       ZConnection1.Connected := True; 
.....	


With best regards
Gerhard
Post Reply