First of all I must say that probably this is NOT A BUG. Certainly it is a lack of knowledge from me.
I call SQL Server stored procedures as "Win32" application with no problem. My problem is that I need to call as ".NET" and I'm not having success.
I attached a small sample (Win32.apt) that I use to call SQL Server stored procedures as "Win32" application with no problem. This sample uses "OdrPrepareProc()".
I also attached the same sample as ".NET" application. In this one, I try to call the stored procedure using "OdrPrepareProc()" with SqlConnect() OR SqlConnectDotNet() and I have errors with both.
Error with SqlConnectDotNet: Could not find stored procedure '@nRet int exec SPR_TEST @param1,@param2,@nRet OUTPUT select @nRet'.
Error with SqlConnect: [Microsoft][ODBC SQL Server Driver]Invalid parameter type.
I also tried with "SqlPrepareSP()" instead "OdrPrepareProc()" with no success.
I ask your help please. Any tip is welcome.
I had success.
Samples attached as my contribution for the forum.
PS: In the samples, running with SqlConnectDotNet() works fine. If you run with SqlConnect() the result is not the same and I don't know why. If one of you figure out the problem, please let me know.
Who is online
Users browsing this forum: [Ccbot] and 0 guests