Devart Forums

Posted: **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

Posted: **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.

Posted: **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?

Posted: **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

Devart Forums

Get latest SQL Native Client (SQL 2005)

Get latest SQL Native Client (SQL 2005)