[dba-VB] Unspecified Error

Hi All --

When no linked tables used then it still fails after 69633 runs :(

TestConnection.ERROR:Unspecified error
29/10/2010 22:42:23: 7733. ThreadCount = 70
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
29/10/2010 22:42:23: 7734. ThreadCount = 72
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
29/10/2010 22:42:23: 7735. ThreadCount = 75
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
29/10/2010 22:42:24: 7736. ThreadCount = 79
TestConnection.ERROR:Unspecified error
TestConnection.ERROR:Unspecified error
29/10/2010 22:42:25: 7737. ThreadCount = 75
StartTime = 29/10/2010 21:59:33, EndTime = 29/10/2010 22:42:25
OK, TotalCount = 69633, ElapsedTime = 0.7142 hours, ErrCount = 32 

Definitedly I have to switch this application to MS SQL CE backend...

Thank you.

--
Shamil
 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: 29 ??????? 2010 ?. 22:23
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: Re: [dba-VB] Unspecified Error

 
Hi All --

As expected linked tables fail with the same error as the case when IN
clause is used. FullStop.

I have to reprogram my solution now :(

Thank you.

--
Shamil
 
-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: 29 ??????? 2010 ?. 22:09
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: Re: [dba-VB] Unspecified Error

Thank you, John,

Yes, I'm glad too but that still means some reprogramming because I used IN
clause in several places in one custom application...

Well, first of all I will try to use linked tables instead of IN clause.
If that works (I doubt it will) then it will be the most easy solution.
Although then I will have to find a way how to reattach linked tables from
.NET C# code without using DAO - using OleDB preferably.
Is it possible at all? Anybody here knows how to do such reattachment?

If linked tables will not work then I will have to reprogram even more...

Thank you.

--
Shamil

<<< snip >>>

_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com