Page 1 of 1
Dbexspda30.dll 4.55.0.23 and SQLServer 2008 R2
Posted: Wed 29 Sep 2010 07:59
by Johan_
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
Posted: Wed 29 Sep 2010 14:36
by Dimon
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'.
Posted: Thu 30 Sep 2010 12:56
by Johan_
I'm using TSQLConnection. Setting the vendorlib param to sqlncli makes no difference.
Posted: Tue 05 Oct 2010 09:08
by Dimon
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.
Posted: Tue 05 Oct 2010 10:11
by Johan_
We use BDS 2006, this makes no difference.
Posted: Wed 06 Oct 2010 09:53
by Dimon
Please make sure that you have SQL Native Client 2008 installed on your client PC.
Posted: Mon 18 Oct 2010 11:19
by Johan_
Thanks a bunch! This solved the problem.
Posted: Mon 18 Oct 2010 11:47
by AndreyZ
It is good to see that this problem has been solved. Feel free to contact us if you have any further questions about SDAC.