Devart Forums

Hello,
Please advise If dbExpress ver 3/4 and SDAC drivers use Microsoft SQL Server Native Client how can we know it?
In case they don't how can we force dbExpress and SDAC drivers to use SQL Server Native Client even when user doesn't have Microsoft SQL Server Native Client installed on client machine system should give the error

thanks in advance

Hello,

Both dbExpress driver for SQL Server and SDAC can use SQL Native Client. To make dbExpress driver for SQL Server use SQL Native Client, you should set the TSQLConenction.VendorLib property to sqlncli.dll or sqlncli10.dll (SQL Native Client 10). To make SDAC use SQL Native Client, you should set the TMSConnection.Options.Provider property to prNativeClient. If you make dbExpress driver for SQL Server or SDAC use SQL Native Client and there is no SQL Native Client installed, an error will occur.

Hello,

Why when I'm setting the TSQLConnection.VendorLib property to sqlncli10.dll and SQL Server 2005 is installed on my PC (only sclncli.dll appears in C:\Windows\System32) I don't ger the error "Required provider is not installed" ?

Thank you for the information. We have fixed this problem. This fix will be included in the next dbExpress driver for SQL Server build.

This fix will be included in version 5.0.3? Could you provide the estimated date of dbExpress driver for SQL Server ?

We will release the next dbExpress driver for SQL Server build approximately in a month or two. But if you need this fix as soon as possible, we can send you a custom dbExpress driver for SQL Server build with this fix. Please send me your dbExpress driver for SQL Server license number to andreyz*devart*com.