Need Sample ODBC call to execute a SQL stored procedure

[BRIAN DOBBINS]

We are coding our first interface that needs to execute a SQL stored procedure and read the return values.  Does any one have an example of how to connect, execute, and process the result row set from a SQL stored procedure.  

The SQL stored procedure uses one input (Account Number) and returns a record set with the Physician Numbers and Names that are associated with the Account Number.

Thank you in advance for any assistance.

Topic

[Jim Kosloskey]

Brian,

Is this an Oracle Stored Procedure?

Apparently there is a difference in calling Oracle Stored Procedures versus SQL Server Stored Procedures.

There may also be differences with calling other DBs Stored Procedures as well. I have just experienced the differences between Oracle and SQL Server.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[BRIAN DOBBINS]

Jim,

This will be a Microsoft SQL Server 2005 server.  We are running  Cover Leaf 5.6 Rev 2 in a Windows environment.

[Russ Ross]

This URL might be of some help

https://usspvlclovertch2.infor.com/viewtopic.php?t=2143&

and searching the forum for key words like SQL or ODBC might lead you to some other useful posts.

Russ Ross
RussRoss318@gmail.com

[Author]

Replies