Re: Attempting an ODBC/DSN connection to Oracle

On Sat, 1 Feb 2003 14:35:30 -0800, leg_spinner <mayur_at_ecst.csuchico.edu> wrote:

>
>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

As you aren't using the Oracle ODBC driver you probably don't have the ODBC test program.
You still could enable tracing the ODBC connection using the ODBC administrator applet in control panel.
You could also trace sqlnet by setting the trace_level in sqlnet.ora. How to do that I have posted *many* times to this group.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Feb 01 2003 - 16:46:53 CST