Get latest SQL Native Client (SQL 2005)

oodesigns · Post by **oodesigns** » Tue 23 Oct 2007 08:03

Hi

In another message I saw someone was getting the error TCP Client: You have been forceable disconnected. Your answer was to get the lastest SQL Natvie client. Where do you get this from? I am not using the connection string when connecting just setting server,database. Should I be setting something else to make it more reliable.

Mike

Antaeus · Post by **Antaeus** » Tue 23 Oct 2007 14:53

You can download it by this link. Set the TMSConnection.Options.Provider to prNativeClient to make sure that this provider is used by your application.

oodesigns · Post by **oodesigns** » Wed 24 Oct 2007 06:32

I am using Version 3 due to known issues with 4 and I do not have that option.

What else can I set?

Antaeus · Post by **Antaeus** » Wed 24 Oct 2007 14:16

To do the same with SDAC 3, you should add the Provider parameter to TMSConnection.ConnectString:

Code: Select all

  Provider=SQLNCLI.1  // to use SQL Native Client provider

Code: Select all

  Provider=SQLOLEDB.1  // to use SQL OLEDB provider