Re: Accessing Oracle 8i with ASP and ODBC

In article <8v1ish$1ut$1_at_nnrp1.deja.com>,   narcolepsy_at_my-deja.com wrote (in part):
> However, I would say about 4-10 times a day, for some
> reason, the connection between the ASP page and the Oracle server
 dies,
> and the ASP page returns an Oracle error TNS:Connection Lost.
 However, I then
> noticed the same exact thing would happen when I was using MSAccess to
> link the Oracle tables so I could access the data locally. I would be
> right in the middle of something, and poof, "ODBC called failed".
> The DBA thinks I am crazy because he claims that he has never received
> the error, even though his workstation is set up identically to mine
> (nt server, sp6) and he does a fair amount of development as well
> (mainly with DLLs however). Any ideas? Right now it is more of an
> annoyance than anything else, but when I have to promote to code to
> production, I want to be sure that everything is going to remain
> stable. Are there any tests I could do? Has anyone seen this issue
> before? I appreciate any help and thank you in advance.

Is it possible that there's a physical network problem that's affecting you and not the DBA? We've encountered cases where things like this were occuring because the network was causing the connection to be dropped.

When an ODBC driver encounters a problem like a dropped connection, it will give very specific error codes to indicate the problem. Applications should be coded to check these status codes and, where appropriate, to re-establish the connection. I'm not certain how ADO reports these error conditions, but I assume it does.

--
Justin Cave - Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of
Oracle Corporation.


Sent via Deja.com http://www.deja.com/
Before you buy.