Support for MS SQL 2008 RTM

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 113
Joined: Wed 16 Mar 2005 16:02
Location: Odense, Denmark

Support for MS SQL 2008 RTM

Post by kurtbilde » Fri 15 Aug 2008 15:44


Does the latest version fully support MS SQL 2008?


Posts: 17
Joined: Fri 15 Aug 2008 18:09

Support for MS SQL 2008 RTM

Post by Vladimir » Fri 15 Aug 2008 18:14

I am also interested to know when SDAC would be able to use SQL 2008 native client.

Provider=SQLNCLI.1;Data Source= ... does not work with no SQL 2005 client installed. I.e. when prNativeClient is specified as provider, SDAC points to Sqlncli.dll and NOT to Sqlncli10.dll . We checked SDAC source code and there is no mention of sqlncli10.dll, just Sqlncli.dll. For example, see code for GetProviderName function in OLEDBAccess.pas

When using prNativeClient(SQLNCLI.1) an attempt is made to log in into SQL Server, this error happens:
Logging on to server (local), database [db name] using trusted connection failed with exception : "Required provider is not installed".

To duplicate: on a clean windows install (or uninstall SQL 2005 Client), with SQL Server Native Client 10.0 installed only, try to use prNativeClient and you will get the same error.

Please provide SQL 2008 RTM support ASAP.
Thank you!

Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 22 Aug 2008 11:49

New build of SDAC version includes support of MS SQL Server 2008 Native Client.

Post Reply