Attempting an ODBC/DSN connection to Oracle

From: leg_spinner <mayur_at_ecst.csuchico.edu>
Date: Sat, 1 Feb 2003 14:35:30 -0800
Message-ID: <Pine.GHP.4.05.10302011403440.287-100000@smilodon.ecst.csuchico.edu>

I have a Solaris server running Oracle 8.1.7 and, Websphere Series and Integrator.

When I try to create a Websphere broker I get the following error message: BIP8040E: Unable to connect to the database. The database cannot be accessed with the userid and password that were specified when when the broker was created. Check that the database is running, that an ODBC connection has been created and that the userid and password pair specified for ODBC connect on the mqsi command are capable of being used to connect to the database using an ODB action. Also ensure that the database has a adequate number of database connections available for use.

In the DSN setup on my machine, I have defined the following: [ODBC Data Sources]
MYBRKDSN=MERANT 3.70 Oracle 8 Driver

[MYBRKDSN]
Driver=/opt/wmqi/merant/lib/UKor816.so
WorkArounds=536870912
WorkArounds2=2
Description=Oracle8
ServerName=orcl.world
EnableDescribeParam=1
OptimizePrepare=1

my tnsname.ora is as follows:
orcl.world =

(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (Host=myhost)(Port = 1521))

                )


                (CONNECT_DATA =

                   (SERVICE_NAME = orcl)
                )
                )

I can get into the Oracle database from my machine via SQL*Net using the userid and password that I created.

How do i manually check that an ODBC connection has been created, and that the userid and password pair specified are capable of being used to connect to the database using an ODBC connection.

Any pointers would be of great help.

Thank you,
mayur Received on Sat Feb 01 2003 - 16:35:30 CST