All Forums Database
11 May 2015
Execute Teradata Stored Procedure from SQL Server

I need to execute a Teradata stored procedure in SQL Server.
I tried so far the following:
1) exec ('call CIONESCU.stp_agg_3 ();') at [Teradata_CIONESCU]
2) select 1 from openquery (Teradata_CIONESCU,'call CIONESCU.stp_agg_3 ();')
error: OLE DB provider "MSDASQL" for linked server "Teradata_CIONESCU" returned message "[Teradata][ODBC Teradata Driver][Teradata Database] Invalid session mode for procedure execution. ".
Any ideas?

Fred 1096 posts Joined 08/04
13 May 2015

A stored procedure can only be called in the same mode (Teradata BTET or ANSI) used to define the procedure. Change the Session Mode option in the ODBC DSN configuration.

You must sign in to leave a comment.