Page 1 of 1

Zeos 7.1.4 Stable and MsSQL error on connect

Posted: 24.02.2015, 18:43
by flamer0n
When connecting to MsSQL (protocol "mssql") an error is thrown [" " is not a valid integer value] whenever the "Connect" of ZConnection is called.

The same problem is in 7.2.0 Beta but not in 7.1.3a Stable (which is the one I'm still using to build LazSqlX)

Development Environment: Lazarus 1.2.6 with FPC 2.6.4 (on Windows 7 64bit)

Re: Zeos 7.1.4 Stable and MsSQL error on connect

Posted: 26.02.2015, 12:46
by miab3
@flamer0n,

Have you tried instead mssql, FreeTDS?
It should work on Win32/64 and Linux32/64.

Michal

Re: Zeos 7.1.4 Stable and MsSQL error on connect

Posted: 26.02.2015, 13:22
by flamer0n
@miab thank you, that was it! I guess I'll stop using 'mssql' protocol when using zeos connection.

Re: Zeos 7.1.4 Stable and MsSQL error on connect

Posted: 26.02.2015, 13:40
by flamer0n
FreeTDS works with older versions of sql servers but fails to connect to sql server 2014. Choosing protocol 'mssql' which I understand uses ntwdblib.dll connects without a problem to an SQL Server 2014. So I'm still stuck using 'mssql' with 7.1.3a ...