MSSQL Connection.

[stag76]

I'm using Version 7.1.2-Stable to Access a MSSQL DataBase using TZConnection.
I can connect to the (LOCAL) instance, but cannot connect to an instance
on another Machine. I'm using ntwdblib.dll.

Is this a limitation of this Version, or or is it more likely to be mistakes in my code?

[marsupilami]

Hello,

this is not enough information to really know what is going on on your computer. Can you proveide some sample code that shows what you do? It can be a problem in your code as well as a misconfiguration on the other host (i.e. TCP being disabled for MS SQL Server).

Some suggestions:

• Use Zeos 7.2. Zeos 7.1 is not supported for quite some time yet.
• Use FreeTDS instead of ntwdblib.dll. FreeTDS has better support for new data types and internationalization.

Best regards,

Jan

[stag76]

Thanks for the reply.

I'll work on updating my Software first.