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(HandleRef 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.fetchNewWorkLogs(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

 

[Dennis Kuntzemann]

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