Page 1 of 1

MSSQL + FreeTDS proper version of TDS

Posted: 15.11.2014, 13:18
by ChrisCross
Small fix for setting the version after login on MSSQL using FreeTDS.

Code: Select all

 function TZFreeTDSBasePlainDriver.dbLogin: PLOGINREC;
 begin
   Result := inherited dbLogin;
  if not Assigned(Result)  then
if not Assigned(Result) then must be if Assigned(Result).

patch in atachment

Re: MSSQL + FreeTDS proper version of TDS

Posted: 16.11.2014, 22:31
by EgonHugeist
ME again :D

If i apply the patch.. I've proplems with the GUID values. Any ideas?

Have to track what happens with TDS..

Re: MSSQL + FreeTDS proper version of TDS

Posted: 16.11.2014, 23:24
by ChrisCross
I also have problems but with nvarchar fields ... an error about utf standard.

Converting nvarchar to varchar column lose the error but i have to investigate/replicate the error.

Hope to give you an example about this issue also.

Activating debug on freetds may help also with your issue. (TDSDUMP or dump file in http://freetds.schemamania.org/userguid ... dsconf.htm )

Re: MSSQL + FreeTDS proper version of TDS

Posted: 17.11.2014, 12:31
by EgonHugeist
Strange i do NOT have problems with N(VAR)Char fields.

But i'm using the N'Value' or N:MyParam Syntax. This is a notification for TDS and Zeos which encoding should be used. Could you tests it? Just to be on same bandwidth...

Re: MSSQL + FreeTDS proper version of TDS

Posted: 17.11.2014, 17:13
by EgonHugeist
Note i got some more errors, running simultan more than one connection...