dbExpress and SDAC drivers use SQL Server Native Client?

galit · Post by **galit** » Wed 21 Dec 2011 08:50

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

AndreyZ · Post by **AndreyZ** » Wed 21 Dec 2011 15:23

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.

galit · Post by **galit** » Thu 29 Dec 2011 08:59

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" ?

AndreyZ · Post by **AndreyZ** » Thu 29 Dec 2011 15:22

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

galit · Post by **galit** » Mon 02 Jan 2012 12:54

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

AndreyZ · Post by **AndreyZ** » Tue 03 Jan 2012 12:06

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.