Problem Handling Huge number of recordsets 
Author Message
 Problem Handling Huge number of recordsets
HI!
   I am doing a datawarehousing project in which i need to
get all the tables using disconnected recordsets. I am
facing a problem during the 768th record as the error
comes as "Arguments are of wrong type,are out of
acceptable range, or are in conflictwith one another"
it works fine for all 767 records where the total number
are 4000 records.

If anyone have any idea plz. reply to this msg ASAP.

thank you
DJ



Sun, 27 Jun 2004 02:00:28 GMT
 Problem Handling Huge number of recordsets

Hi,

What do you do with this 768th record? Without code
probably we could not help you?

Val

Quote:
>-----Original Message-----
>HI!
>   I am doing a datawarehousing project in which i need
to
>get all the tables using disconnected recordsets. I am
>facing a problem during the 768th record as the error
>comes as "Arguments are of wrong type,are out of
>acceptable range, or are in conflictwith one another"
>it works fine for all 767 records where the total number
>are 4000 records.

>If anyone have any idea plz. reply to this msg ASAP.

>thank you
>DJ
>.



Sun, 27 Jun 2004 02:11:37 GMT
 Problem Handling Huge number of recordsets
HI Val,
Yes you are right.
We can't tell anything without looking at the actual data.
But I am making one guess( it happened with me in past),
please check your error occured row..for #error in all columns of your
table.
I think data is corrupted in that row.

Harinatha Reddy Gorla
        Software Engineer
Smart Software Technologies,
Hyderabad, India

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sun, 27 Jun 2004 14:18:03 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. handling a huge database

2. Any experience in handling huge objects?

3. Handle huge table

4. Handle huge table

5. Handling a huge amount of data quickly

6. SQLServer and Web Server for huge user numbers

7. Using varchar to represent huge numbers

8. !#@!![?] Insanely huge number error

9. What could be causing huge number of semops?

10. DBMS for (huge number of) time series?

11. anything bad with huge ADO recordset?

12. Break up Huge Recordset


 
Powered by phpBB® Forum Software