Support for MS SQL 2008 RTM
Posted: Fri 15 Aug 2008 15:44
Hi,
Does the latest version fully support MS SQL 2008?
-Kurt
Does the latest version fully support MS SQL 2008?
-Kurt
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!