exec sp_datatype_info gives error in SDAC 7.1.6 in prDirect Mode
Posted: 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.
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.