Hi, I'm using a VB component whi

[Teksaravana]

Hi,

I'm using a VB component which does the job of deleting the records in the volume of 2 to 3 million.

For deleting records i used four different stored procedures

My problem is while doing so only one or two sp only gets executed and not deleting all the records.

Is it because of ADO Connection time out?

 

[Dimandja]

Do you have any reason to suspect an ADO timeout?

Without seeing and debugging your code, all bets are off. You may want to try the Visual Basic forum or a forum dedicated to ADO or to the particular database engine you are using.

The problem could be found anywhere in those components. You'll need to narrow the search down a bit by debugging some.

Dimandja

 

[harebrain]

To add to Dimandja's advice, another suspect problem area is the driver: OLEDB, ODBC -- what are you using?