Unspecified Error

Thread View: borland.public.cppbuilder.database.ado

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by John Borchers Tue, 08 Mar 2005 13:50

#921

Author: John Borchers
Date: Tue, 08 Mar 2005 13:50

8 lines
1019 bytes

All,

Why might one get an Unspecified Error EOleException during an ADO (ODBC 
MDB) connection?

Thanks,

John

Re: Unspecified Error

#922

Author: Vladimir Stefanovic
Date: Tue, 08 Mar 2005 17:33

27 lines
1504 bytes

I just got that error yesterday during a very long
procedure on one Celeron 1,7Mhz.

It was ADO & MDB involved in an operation. There
wasn't any complicated code - but was processing a
lot of records (400,000) and the program chrashed maybe
on 30% completed.

On the other (more powerful) machine, the procedure
succeded.



-- 
Best regards,
Vladimir Stefanovic
"John Borchers" <jborchers@notmail.com> wrote in message 
news:422dada8@newsgroups.borland.com...
> All,
>
> Why might one get an Unspecified Error EOleException during an ADO (ODBC 
> MDB) connection?
>
> Thanks,
>
> John
>

Re: Unspecified Error

#923

Author: John
Date: Wed, 09 Mar 2005 00:40

59 lines
2483 bytes

Vladimir:

This seems a connection problem to MDB with ADO

This solves it:

 try
  {
   ADOConnection1->Connected=true;
  }
 catch(EOleException &E)
  {
   ADOConnection1->Connected=false;
   Sleep(5000);
   ADOConnection1->Connected=true;
  }
 try
  {
   ADOQuery1->Active=true;
  }
 catch(Exception &E)
  {
   ShowMessage("Unexpected exception during this procedure "+E.Message);
  }

John


"Vladimir Stefanovic" <antivari@po.sbb.co.yu> wrote in message 
news:422de1c5@newsgroups.borland.com...
>I just got that error yesterday during a very long
> procedure on one Celeron 1,7Mhz.
>
> It was ADO & MDB involved in an operation. There
> wasn't any complicated code - but was processing a
> lot of records (400,000) and the program chrashed maybe
> on 30% completed.
>
> On the other (more powerful) machine, the procedure
> succeded.
>
>
>
> -- 
> Best regards,
> Vladimir Stefanovic
> "John Borchers" <jborchers@notmail.com> wrote in message 
> news:422dada8@newsgroups.borland.com...
>> All,
>>
>> Why might one get an Unspecified Error EOleException during an ADO (ODBC 
>> MDB) connection?
>>
>> Thanks,
>>
>> John
>>
>
>

Re: Unspecified Error

#924

Author: John
Date: Wed, 09 Mar 2005 01:51

61 lines
2273 bytes

Vladimir:

This seems to happen to me on connection. How about you?

I can solve it by doing this:

try
  {
   ADOConnection1->Connected=true;
  }
 catch(EOleException &E)
  {
   ADOConnection1->Connected=false;
   Sleep(5000);
   ADOConnection1->Connected=true;
  }
 try
  {
   ADOQuery1->Active=true;
  }
 catch(Exception &E)
  {
   ShowMessage("Unexpected exception during work"+E.Message);
  }

If my application does connection, disconnection, connection, then the 
exception gets thrown.

John

"Vladimir Stefanovic" <antivari@po.sbb.co.yu> wrote in message 
news:422de1c5@newsgroups.borland.com...
>I just got that error yesterday during a very long
> procedure on one Celeron 1,7Mhz.
>
> It was ADO & MDB involved in an operation. There
> wasn't any complicated code - but was processing a
> lot of records (400,000) and the program chrashed maybe
> on 30% completed.
>
> On the other (more powerful) machine, the procedure
> succeded.
>
>
>
> -- 
> Best regards,
> Vladimir Stefanovic
> "John Borchers" <jborchers@notmail.com> wrote in message 
> news:422dada8@newsgroups.borland.com...
>> All,
>>
>> Why might one get an Unspecified Error EOleException during an ADO (ODBC 
>> MDB) connection?
>>
>> Thanks,
>>
>> John
>>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads