I was using SQLProcedureColumns() to retrieve the input/output parameter information of a stored procedure. It happens that there are two stored procedures with the same name in my test database, but they have different parameter lists. When I pass the procedure name to SQLProcedureColumns(), it returns to me *all* the parameters from both of the functions. For example,
Calling SQLProcedureColumns() will return param1, param2 and param3 as the result.
Is there a way to correctly tell which stored procedure I am actually referring to? It seems that SQLProcedureColumns() is limited by the API itself and only accepts procedure name (and other schema name) as the argument.