VB6 Crashes when accessing Oracle Database Stored Procedure

[IQ]

I have connected to an Oracle 8.0.4 database using Microsofts OLEDB Provider for Oracle. <br><br>( I have installed MDAC 2.5).&nbsp;&nbsp;<br><br>When I try to execute a stored procedure which returns more than 8 fields in a recordset VB6 crashes completely.<br><br>If I reduce the number of fields the recordset works OK.<br><br>Anybody got any ideas ?<br><br>Thanks<br>Ian Q

 

[chiph]

Haven't tried the OLEDB stuff yet.&nbsp;&nbsp;I've always used ADO/ODBC to connect.&nbsp;&nbsp;What happens if you use ADO?<br><br>Chip H.<br>

 

[JimHorton]

Ian,<br>Have you determined that 8 is the magic number of fields at which it crashes and not a certain data type?&nbsp;&nbsp;ie maybe the field you removed to make it 8 fields was the problem, I know recordsets under&nbsp;&nbsp;older ODBC drivers would get goofy with date fields, and removing the date fields would make everything alright, regardless of how many other fields were there.&nbsp;&nbsp;<br>--Jim

 

[IQ]

Jim,<br><br>It does appear to be 8, I have selected purely numeric data fields from the table and the same thing happens. <br><br>Have you successfully used the Microsoft OLEDB Driver for Oracle v2.5 to connect to Oracle yet?<br><br><br>Ian

 

[JimHorton]

No I haven't tried OLEDB at all, just ADO and ODBC/DAO.&nbsp;&nbsp;I have MDAC installed, it came w/VB6-Ent, I'll give it a try and see if I can reproduce the error.<br>--Jim

 

[IQ]

Good news!<br><br>I have attempted to do the same as before, except this time I used NT4.&nbsp;&nbsp;The same problem occurs until I loaded Oracle NET8 version 8.0.5. <br><br>Now it does not seem to matter how many parameters I return.<br><br>IanQ

 

[chiph]

IQ -<br><br>So, using the MS OLE-DB connection, it barfs at 8 parameters, but if you switch to the Oracle 8 driver, everything's fine?&nbsp;&nbsp;If this &quot;feature&quot; isn't listed in the MS Knowledgebase, and if you've got the spare time, you might want to call MS product support and send them some sample code.&nbsp;&nbsp;Those guys love to get their names on a KB entry, I think they get a bonus or something.<br><br>Chip H.<br>