Stored Procedure and ADO 
Author Message
 Stored Procedure and ADO
Hi,
I have a DB2 database (UDB 7.1)  with a simple Java stored procedure that
should return a result set.
When I call my stored procedure from Visual Basic (V6/SP4)  using
ADO(2.5)/OLEDB or ADO(2.5)/ODBC I get a resultset back from Database , but
the field names are not being passed back to me and instead I have an ADO
recordset with "C0", "C1",... as my field names.
Is this my stored procedure or there is FIX for this out there ?

Thanks
Saeid



Sat, 05 Jul 2003 15:16:36 GMT
 Stored Procedure and ADO

I found my answer , I was using SQLJ and as soon as I changed the code to
use JDBC it worked fine.
I just don't know why SQLJ does that !?

Quote:
> Hi,
> I have a DB2 database (UDB 7.1)  with a simple Java stored procedure that
> should return a result set.
> When I call my stored procedure from Visual Basic (V6/SP4)  using
> ADO(2.5)/OLEDB or ADO(2.5)/ODBC I get a resultset back from Database , but
> the field names are not being passed back to me and instead I have an ADO
> recordset with "C0", "C1",... as my field names.
> Is this my stored procedure or there is FIX for this out there ?

> Thanks
> Saeid



Tue, 08 Jul 2003 13:33:46 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. stored procedure and ADO

2. Message from SQL Stored Procedure to ADO

3. Case Statment in Stored Procedure Creates ADO Error

4. Problem with executing stored procedures using ADO

5. Extended Stored Procedure using ADO 2.5 (SP2)

6. Cancelling a Stored Procedure through ADO

7. Errorhandling in stored procedure and ADO

8. retrieving data from stored procedure with ADO

9. call stored procedure using ADO in vc++?

10. Calling stored procedures from ADO in VB

11. Passing parameters to a Stored Procedure using ADO

12. Passing Time parameter to a Stored Procedure using ADO


 
Powered by phpBB® Forum Software