We help IT Professionals succeed at work.
Get Started

ADO & RDO Error

donotknow
donotknow asked
on
525 Views
Last Modified: 2013-12-25
Hello!

  I've been trying to find a solution for these errors and I can't, can somebody help me please ???

  I'm using VB6 to access an Oracle Database, but I need to execute a BIG length SQL (more than 120 words) using either ADO or RDO technology...

The error that I get using RDO is: "NOT ENOUGH STACK SPACE", while the Error that I get using ADO is: "UNEXPECTED FAILURE"

  If I tried to execute a short lenght SQL like: "Select * from TB", it doesn't produce any error...Why ???
 
  The reason of executing a complex query is that I need to get from a single SQL the data stored in 9 tables, with 19 fields each approximately and parameters, big enough ah!!

  S.O.S  :)
 
  Oh! I forgot, Why is it that the recordcount property always says -1 instead of the number of records obtained through the SQL statement ????
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 14 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE