SQL Server 2012, "TCP dynamic ports"

[Radek]

Hi,

I would like to ask if ZeosLib can connect to SQL Server 2012 using a method of "TCP dynamic ports"?

Best regards,
Radek

[marsupilami]

Hello Radek,

for MS SQL Server that usually will depend on the library that you choose to connect:

• The ADO-Bridge should be capable of doing that if it is supported by the ADO / ODBC drivers of Microsoft.
• The mssql driver uses the ancient ntwdblib.dll that is not supported by microsoft for quite some years now and most probably is not capable of doing that.
• For FreeTDS ist is not known to me if they support that feature and if something would need to be implemented in Zeos to make this a possible solution.

So the answer depends on which driver you use.
Best regards,

Jan

[miab3]

@marsupilami,

For FreeTDS situation is similar to mssql (ntwdblib.dll) but it works for 32 and 64 bits.
Just put on the path adequate FreeTDS *dblib* DLL.

Michal

[Radek]

Hi,

I wonder what should I put in a protocol and host property of TZConnection object in a context of dynamic ports. I need to mention that I use a "FreeTDS_MsSQL>=2005" protocol.


Best regards,
Radek