Re: Connecting to an Oracle database

Hi Bengt,

To connect to Oracle, you need to provide the Server Name, the 'service'
name, the username and the password.

The Server name is the name of the computer hosting Oracle. You may use
the IP address instead of name.

The Service Name is the name of the database on the system as defined in
the 'Listener.ora' file on the host computer and the 'tnsnames.ora' file on
the local computer.

If you are passing a null string as the service name, Oracle will not be
able to find a matching entry for that 'service name' and the will result in
hte ORA-12154 error.

HTH,

Michael

"Bengt Håkansson" <Bengt.Hakansson@xxxxxxxxx> wrote in message
news:43413b94@xxxxxxxxxxxxxxxxxxxxxxxxx
> According to the help text, Servere name should be the name of the
> computer where the database is. If I enter that name together with the
> username I password I used when running the database application (Written
> in Wisual Basic) and press Test connection, I get the message Test
> connection failed because of an error in initializing provider. ORA-12154:
> TNS: could not resolve service name.
>
> /Bengt Håkansson
>


.

Relevant Pages

  • Re: "Correct" term for a 1:1 relationship between a "database" and an "instance" where > 1 such thin
    ... Nearly all the Oracle docs and books define a database something like ... unpartitioned physical server? ...
    (comp.databases.oracle.server)
  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver.odbc)
  • Linked Server (Oracle 9i)
    ... Having problems connecting to an Oracle 9i database from within ... Microsoft ODBC for Oracle ... Windows 2000 - Advanced Server ... OLE DB error trace [OLE/DB Provider 'MSDAORA' ...
    (microsoft.public.sqlserver)
  • RE: C++ Validating SQL user credentials
    ... All I want to do is take SQL credentials: server, database, username, ... CString connectionString = GetConnectionString(authenticationType, server, ...
    (microsoft.public.data.odbc)
  • RE: Vulnerability analysis tools
    ... Definitely you want your Oracle database behind a firewall. ... tell you the database is not meant to be exposed to the internet directly. ... 1- A web server hosted at an IDC ...
    (Security-Basics)