Re: problem connecting to db.

From: Mr. X. <>
Date: Sun, 30 Dec 2007 12:44:05 +0200
Message-ID: <fl7soi$stj$>


As david said :
connection 'sometimes hang', but it isn't a regular occurrence
(He just explained what I have written, in simplier English).
So I don't think there is mistake on tnsnames.ora, since the problem isn't a regular occurence.

But I would add the code, as you suggested, with timeout = 30   (The current situation is as I did : OraCon.CursorLocation = adUseClient, but after OraCon.Open
  (maybe mistakenly, but I suppose, adUseClient is the default ... ). )

I don't know if it is Oracle or not (maybe, network), and BTW, the server and the client are at the same machine (the process is on the server).

It may be problem if I do tracing, because the problem may happens not so so often
(once a day, and sometimes there is not a problem for several days ...)

Please give me briefly what should I do in advanced.

Thanks :) Received on Sun Dec 30 2007 - 04:44:05 CST

Original text of this message