Execute SQL Parameterized Stored Procedures by Using the ODBC .NET Provider

re: Execute SQL Parameterized Stored Procedures by Using the ODBC .NET Provider

Willson Gary — Wed, 04 Mar 2009 08:47:00 GMT

Superblog

Rajesh A — Fri, 05 Oct 2007 12:39:11 GMT

Project background:

------------------

I am using FreeTDS and UnixODBC on RH linux 4.0. We are connecting to Microsoft SQL Server 8.0 from linux. We are using C++ on Linux.

Requirement:

-----------

I am calling Stored Procedure(SP) with input and output parameter and I am also expecting return value as well.

I am calling stored procedure as follows:

{? = CALL stp_returnRow(?, ?, ?)}

In above case I am expecting both return value and output parameter. The first parameter is input and 2nd and 3rd parameter is output parameter.

We are not getting the required values.

please suggest or give me solution if possible.

My email id: rajesh.akolu@ftindia.com

Rajesh A — Fri, 05 Oct 2007 12:38:14 GMT

Project background:

------------------

I am using FreeTDS and UnixODBC on RH linux 4.0. We are connecting to Microsoft SQL Server 8.0 from linux. We are using C++ on Linux.

Requirement:

-----------

I am calling Stored Procedure(SP) with input and output parameter and I am also expecting return value as well.

I am calling stored procedure as follows:

{? = CALL stp_returnRow(?, ?, ?)}

In above case I am expecting both return value and output parameter. The first parameter is input and 2nd and 3rd parameter is output parameter.

We are not getting the required values.

please suggest or give us sample code

Andreas Erben — Sun, 04 Feb 2007 00:15:45 GMT

Good practical introduction to the topic.

"Do you want to know more?":

Generic Coding with the ADO.NET 2.0 Base Classes and Factories