Re: odbc-gurus

 After connecting
> successfully, I did the following:
> rc = SQLNumParams(hstmt,&numCols);
> rc = SQLProcedureColumns(hstmt,NULL,0,(unsigned char*)
> colSchemaNamePattern,len, (unsigned char
> *)"test3",SQL_NTS,(char *)
> colNamePattern,len);
> My rc remains 0 after the call of SQLProcedureColumns, but the
> colSchemaNamePattern is 0 (????) so also colNamePattern. It is
> difficult for
> me make an assertion.

You have to supply colSchemaNamePattern and colNamePattern. For example:

rc = SQLProcedureColumns(hstmt, NULL, 0, "%", SQL_NTS, (SQLCHAR *)"testproc", SQL_NTS, "%", SQL_NTS);
returns a result set that contains all the parameters (coNamePatern == "%") to procedure "testproc". If the user account has access to more than 1 procedure called testproc (mine.testproc and yours.testproc), it

will return information for both.

If you know the name of the procedure, you can use SQLProcedureColumns (on another hstmt). Otherwise, I don't know. Maybe SQLGetDescField, or maybe it is legal to bind all parameters as SQL_PARAM_INPUT_OUTPUT.

> Also, how do I parse the arguments, with SQLFetch(hstmt)?
> Thanks and regards,

Yes. See the ODBC SDK for the columns returned. Received on Tue Mar 01 2005 - 13:39:46 CST