Calling Stored Procedures with ADO/OLE DB under V5R1M0
Andrew Kerr
problem with above.
Under V5R1M0 Service Level SI0795 (Windows 2000 Pro or Windows 98),
the same VB6 code no longer works. ADO version is 2.6
Can see procedure/program execute on AS/400 through QZDAOINIT
successfully. Can prove that RPG program retrieves correct number of
records, yet returned record set is empty in VB front-end.
History Log (history.hst) shows for data access component
CWBDB0035 Server Returned SQL Warning
CWBDB0037 Server Returned SQL Parameter Warning
The following appear in the IBMDA400.log as below
03/14/02 10:22:08 : CDataSource::SetProperties failed. hrSet:
80040E21
03/14/02 10:22:08 : CDataSource::SetProperties returning
DB_E_ERRORSOCCURRED.
These messages also appear in the IBMDA400.trc and it is possible to
see the correct number of rows (e.g. 3) being returned, before the
fail.
03/14/02 10:22:03 : CSQLRowset::GetNextRows lRowsOffset: 0; Number
Rows: 1
03/14/02 10:22:03 : m_nRowInBlock: 1;
m_cRowsInBlock: 3
03/14/02 10:22:03 : CSQLRowset::GetNextRows NewlyCreated rowset
positioning
03/14/02 10:22:03 : GetNextRows returning E_FAIL.
Does anyone have any ideas ? Works still under ODBC!
Olivier Constans
I have encountered problems too with call of stored procedures under CA
Express V5r1 .
I am using Borland Cbuilder with ADO Express and I made a small application
under CA express V4R4 with a RTVJOBA stored procedure which returns job info
to the client.
It was working wery well, but using the same programm with CA V5R1 , I got a
strange error:
Sql7985: Instruction CALL exécutée
Cause...:l'appel à la procédure RTVJOBATRa abouti
(Call has run / call of the RTVJOBATR procedure succeed)
This is an error for oledb... but it said all was ok... and of course no
parameters were retreived from RTVJOBA into my client program !
I think that the problem happened because my AS400 is in V4R3 and maybe
uncompatible with CA express V5R1 , but I am not sure of this, because I
couldn't try my program on an V5R1 OS400 .
There is another bug with CA V5r1 ...if you uninstall it, it will remove
some ADO/oledb windows register key which make ADO unusable until you
reinstall window (give the message "unknow interface" when using ADO
component in Cbuilder even without use it for As400 connnection). It is very
annoying.
Regards
Olivier
"Andrew Kerr" <andre...@centralassessor.demon.co.uk> a écrit dans le
message news: 96483c9e.02032...@posting.google.com...
Andrew Kerr
Having logged my problem with our IBM business partner, they came back
bascially with the solution of "don't use IBMDA400, it is not a
reliable OLE DB provider" and "use a third party product". I find this
incredibly annoying, with IBM promoting ADO as the way to go with the
Express Toolkit plug-in for VB & it appears to no longer work for
stored procedures.