Dbexspda30.dll 4.55.0.23 and SQLServer 2008 R2

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Johan_
Posts: 4
Joined: Wed 29 Sep 2010 07:54

Dbexspda30.dll 4.55.0.23 and SQLServer 2008 R2

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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_
Posts: 4
Joined: Wed 29 Sep 2010 07:54

Post by Johan_ » Thu 30 Sep 2010 12:56

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

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

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_
Posts: 4
Joined: Wed 29 Sep 2010 07:54

Post by Johan_ » Tue 05 Oct 2010 10:11

We use BDS 2006, this makes no difference.

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

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_
Posts: 4
Joined: Wed 29 Sep 2010 07:54

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.

Post Reply