Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB6 RDO ODBC stored procedures

Status
Not open for further replies.

veebee

Programmer
Sep 8, 1999
2
0
0
GB
I am using an RDO interface with an ODBC connection to Universe and am trying to execute stored procedures. I can get the program to work fine and execute the stored procedure when I don't pass any parameters, but as soon as I start to try to pass parameters, I get the following problem.<br>
<br>
I have 2 option buttons in each of two frames and depending on the settings each frame sets a variable which has been defined as a string set to null earlier in the program. I then use the standard syntax of<br>
<br>
rdoQuery_name(parameter number) = variable<br>
<br>
to define the parameter value<br>
<br>
This fails consistently with the error message:<br>
40041 Object collection: couldn't find object indicated by text.<br>
<br>
Can anybody tell me what this error message is actually indicating as the rdoQuery definition statement earlier in the program runs okay, the parameters are defined in the standard way and the variable is present.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top