Zeos 7.1.4 Stable and MsSQL error on connect

[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)

[miab3]

@flamer0n,

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

Michal

[flamer0n]

@miab thank you, that was it! I guess I'll stop using 'mssql' protocol when using zeos connection.

[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 ...