exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
galit
Posts: 18
Joined: Mon 12 Feb 2007 11:07

exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode

Post by galit » Tue 21 Jul 2015 12:05

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.

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

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

Post by azyk » Wed 22 Jul 2015 08:13

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.

galit
Posts: 18
Joined: Mon 12 Feb 2007 11:07

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

Post by galit » Wed 22 Jul 2015 14:02

Hello

About when the next SDAC build should be released?

Thanks

ysyang
Posts: 41
Joined: Tue 14 Jun 2005 09:10

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

Post by ysyang » Thu 23 Jul 2015 22:16

I will wait for your email

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

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

Post by azyk » Fri 07 Aug 2015 08:36

Please let us know whether the problem is resolved.

ysyang
Posts: 41
Joined: Tue 14 Jun 2005 09:10

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

Post by ysyang » Mon 24 Aug 2015 07:17

In the source code you sent me the problem was solved.
Thank you very much

Post Reply