Page 1 of 1

exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Posted: Tue 21 Jul 2015 12:05
by galit
Hello

I use:
Delphi XE6
Win 7 64 bit
SDAC 7.1.6 Pro for Delphi XE6
SQL Server 2008 R2

In my program, I am using ‘prDirect’ provider of the TMSConnection, and I have SQLQuery of type TSDACMSQuery.

I set:
SQLQuery.SQL.Text := 'exec sp_datatype_info';

and then when i call to:
SQLQuery.Execute();

I get the following exception:

The following error has occurred in the application :
Exception class: 'ETDSError'
Exception message: 'The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. The RPC name is invalid.'

In SDAC 6.10.20 for Delphi XE6 this didn't happen.

Please let me know how to solve this ASAP.

Thanks.

Re: exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Posted: Wed 22 Jul 2015 08:13
by azyk
We have reproduced this problem and fixed it. This fix will be included in the next SDAC build. If you want to get this fix before the release of the next SDAC, send your email address and license number to andreyz*devart*com - and we will send you a night build.

Re: exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Posted: Wed 22 Jul 2015 14:02
by galit
Hello

About when the next SDAC build should be released?

Thanks

Re: exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Posted: Thu 23 Jul 2015 22:16
by ysyang
I will wait for your email

Re: exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Posted: Fri 07 Aug 2015 08:36
by azyk
Please let us know whether the problem is resolved.

Re: exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Posted: Mon 24 Aug 2015 07:17
by ysyang
In the source code you sent me the problem was solved.
Thank you very much