Dbexspda30.dll 4.55.0.23 and SQLServer 2008 R2

Johan_ · Post by **Johan_** » Wed 29 Sep 2010 07:59

Using the new DATE column in Server 2008 R2 we get strange responses from the datatype property. The datatype is reported as ftWideString which it should not be.

How do I resolve this?

Best regards,
Johan

Dimon · Post by **Dimon** » Wed 29 Sep 2010 14:36

To map the DATE and TIME SQL Server types to TDateField and TTimeField you should use the SQL Native Client provider. For this you should set the TCRSQLConnection.VendorLib property to 'sqlncli'.

Johan_ · Post by **Johan_** » Thu 30 Sep 2010 12:56

I'm using TSQLConnection. Setting the vendorlib param to sqlncli makes no difference.

Dimon · Post by **Dimon** » Tue 05 Oct 2010 09:08

This problem is connected with the specificity of setting parameters of TSQLConnection in RAD Studio 2007. To solve the problem delete the parameter with the DriverName key from the Params property.

Johan_ · Post by **Johan_** » Tue 05 Oct 2010 10:11

We use BDS 2006, this makes no difference.

Dimon · Post by **Dimon** » Wed 06 Oct 2010 09:53

Please make sure that you have SQL Native Client 2008 installed on your client PC.

Johan_ · Post by **Johan_** » Mon 18 Oct 2010 11:19

Thanks a bunch! This solved the problem.

AndreyZ · Post by **AndreyZ** » Mon 18 Oct 2010 11:47

It is good to see that this problem has been solved. Feel free to contact us if you have any further questions about SDAC.