HandleError?

[Till M]

Hello,

I have an existing database-application which has some problems with
fetching datas from a database server. at the moment we think it has to do
with the workload on the database server, but as we are not really sure i
would like to know your opinion.

first a genearal question: if i have the call:

functionxy(selectWorklogCmd.ExecuteReader(), dest);

is the selectWorklogCmd executed right now or only when the code reaches the
part:
"while (odbcreader.Read)" ?

because this is the part where it takes a long long time and most of the
time the application stops and this point with the message:

7/20/2006 3:56:47 PM Exception: ERROR [42S] Driver]Cannot open catalog;
Message number = 94. prod_race.sie.siemens.at
7/20/2006 3:56:47 PM Stack trace:
at System.Data.Odbc.OdbcConnection.HandleError(Handle Ref hrHandle,
SQL_HANDLE hType, RETCODE retcode)
at System.Data.Odbc.OdbcDataReader.Read()
at Actis.Interface.ActisOdbcInterface.doFetchWorkLogs (OdbcDataReader
reader, MySqlConnection dest, DataTable blackList, Int32& count)
at Actis.Interface.ActisOdbcInterface.fetchNewWorkLog s(MySqlConnection
dest, DataTable blackList, String country)
at Actis.Interface.FetchActisDataService.OnTimedEvent (Object source,
ElapsedEventArgs e)
but like 30 % the queries work, that is so strange.

Has anybody an idea how to solve the problem or why this problem occurs? We
try to transfer data from a oracle db to mysql.
i am not so experienced in the area, so sorry if i forgot to tell you some
important informations and just let me know!

thank u very much in advance!

best regards,

till

[chanmm]

The error shown the database not found. So check the path or server name
perhaps.

chanmm

"Till M" <ti*********@siemens.comwrote in message
news:e9**********@daniel-new.mch.sbs.de...

Hello,

I have an existing database-application which has some problems with
fetching datas from a database server. at the moment we think it has to do
with the workload on the database server, but as we are not really sure i
would like to know your opinion.

first a genearal question: if i have the call:

functionxy(selectWorklogCmd.ExecuteReader(), dest);

is the selectWorklogCmd executed right now or only when the code reaches
the
part:
"while (odbcreader.Read)" ?

because this is the part where it takes a long long time and most of the
time the application stops and this point with the message:

7/20/2006 3:56:47 PM Exception: ERROR [42S] Driver]Cannot open catalog;
Message number = 94. prod_race.sie.siemens.at
7/20/2006 3:56:47 PM Stack trace:
at System.Data.Odbc.OdbcConnection.HandleError(Handle Ref hrHandle,
SQL_HANDLE hType, RETCODE retcode)
at System.Data.Odbc.OdbcDataReader.Read()
at Actis.Interface.ActisOdbcInterface.doFetchWorkLogs (OdbcDataReader
reader, MySqlConnection dest, DataTable blackList, Int32& count)
at Actis.Interface.ActisOdbcInterface.fetchNewWorkLog s(MySqlConnection
dest, DataTable blackList, String country)
at Actis.Interface.FetchActisDataService.OnTimedEvent (Object source,
ElapsedEventArgs e)
but like 30 % the queries work, that is so strange.

Has anybody an idea how to solve the problem or why this problem occurs?
We
try to transfer data from a oracle db to mysql.
i am not so experienced in the area, so sorry if i forgot to tell you some
important informations and just let me know!

thank u very much in advance!

best regards,

till

[Dennis Kuntzemann]

"chanmm" <ch*****@hotmail.comwrote in message
news:eQ****************@TK2MSFTNGP05.phx.gbl...

The error shown the database not found. So check the path or server name
perhaps.

chanmm

Thank you for your answer!
but how can it be possible, because in 30 % of the cases the database
queries are successful, so the database path is found. Can anybody explain
it?

thanks again!

till