Hello all!
I'm trying to get the ODBC driver for Oracle working on my Digital UNIX 4.0D
box (Alpha Server 2100), and I'm not having very much luck. The base
directory for the driver software is /var/opt/DAU100, and the odbc.ini file
is in the /var/opt/DAU100/connect directory. The relevant lines in this file
are:
[ODBC Data Sources]
Oracle7=medev
[Oracle7]
Driver=/var/opt/DAU100/connect/lib/ivor712.so
Description=Oracle7
ServerName=TNS:medev
LogonID=query_dude
Password=query
medev is the name of the database that I'm trying to connect to, and it's
also the name of the sqlnet connection. I've run the
/var/opt/DAU100/connect/odbc.sh script, as well as set the ODBCINI variable
to /var/opt/DAU100/connect/odbc.ini. I've also set DSN=medev and
SRVR=TNS:medev. When running the "/var/opt/DAU100/connect/demo/demoodbc -uid
query_dude -pwd query medev" string, I get the following messages:
demoodbc INTERSOLV, Inc. ODBC Sample Application.
demoodbc: will connect to driver medev
SQLConnect: Failed...
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [INTERSOLV][ODBC lib] Data source name not found and no default
driver specified
SQLConnect: Retrying Connect.
SQLConnect: Failed...
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [INTERSOLV][ODBC lib] Data source name not found and no default
driver specified
SQLConnect: Retrying Connect.
SQLConnect: Failed...
SQLSTATE = IM002
NATIVE ERROR = 0
MSG = [INTERSOLV][ODBC lib] Data source name not found and no default
driver specified
SQLConnect: Retrying Connect.
No connection could be established.
Can anyone point out what I'm missing and/or what I need to do.
Thanks!
-Stephen Spalding
PS - My goal is to get ODBC working so that I can connect to SQL Server on
an NT box.
Received on Tue Sep 14 1999 - 19:32:40 NZST