Re: OracleClient Connection string ..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Roy Fine (rlfine_at_twt.obfuscate.net)
Date: 05/01/04 

Date: Fri, 30 Apr 2004 22:17:07 -0400

"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
news:u$H5gZWKEHA.204@TK2MSFTNGP10.phx.gbl...
>
> ".Net Developer" <""> wrote in message
> news:uyDXsFWKEHA.3472@TK2MSFTNGP09.phx.gbl...
> > thanks for the reponse, Bill.
> > I changed the Integrated Security to "false" but still receive the same
> > error. Any clues why?
> Not off of the top of my head, that's definitely weird. Do you have a
> Server specified in your TNSnames.ora file? If so, try pinging it and
make
> sure you can make the connection. Also what's specified in sqlnet.ora
>

tnsping does not make a connection to the database - it only verifies that a
listener is available on the port and host specified in the alias.

Service Name refers to the name of the database - if you are using local
naming, it is specified in the tnsnames.ora file. make sure that the
service name is complete with the domain, or that you have specified the
default domain in the sqlnet.ora config file.

regards
roy fine

Relevant Pages

  • Re: Try Catch Else Finally
    ... are turning into a vicious loop in my head. ... there is some other exception that is thrown other than creating the connection. ... It could be due to a null in the database that is not handled by the data reader, a column that is removed from the database, a database timeout, anything. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • ANN: Sequel 3.11.0 Released
    ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... for constructing database queries and table schemas. ...
    (comp.lang.ruby)
  • ANN: Sequel 3.9.0 Released
    ... Sequel is a lightweight database access toolkit for Ruby. ... Sequel provides thread safety, connection pooling and a concise DSL ... the default connection pool no longer contains ...
    (comp.lang.ruby)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)