Hi, I am trying to execute a stored procedure from Visual Studio 2012 using the .Net drivers. I am connecting thru LDAP, the character set is UTF8, session mode is ANSI.
In Teradata studio, after running
help procedure xxx.xxxx attributes;
I can see Character set = UTF8 ; platform is UNIX, collation is ASCII, transaction semantics is ANSI.
I can't set the TMODE In ADO connectin string.
There are no parameters, just using Sqlstatement call xxx.samplesp()
With isQuery storedprocedure set to true, no resultset, sqlsourcetpye direct.
It jsut returns with  Invalid session mode for procedure execution. Have tried a few settings
Any ideas please?
Corresponding keyword for .NET provider is "Session Mode" instead of "TMODE".
Hi, thanks for taking the time to reply back. I worked around the issue by placing the connection string into a connection expression. Unfortunetly, now I am getting a 5497 CAll cannot be submitted in multi statement request.
I tried it on a blank SP, I tried changing TMODEs etc. But I cannot get SSIS to call a SP using an Execute Sql Task. I can execute using script task. do you know if it is possible to avoid the multi statement error?
thanks in advance
Have you tried ODBC? I ran a few simple SSIS tests and it appears to work when you set ODBC session mode according to how SP was created. Looks like SSIS does not like ANSI session mode w/ .NET. Will look into it.