help with sqlwindows and oracle 7.3 connectivity
Date: 1997/07/14
Message-ID: <33C9942F.C6213B05_at_intrahealth.co.nz>#1/1
I can't seem to get sql windows 5.0.3 running on a win95 client to talk to Oracle 7.3 running on an NT 4 server. I'm trying to connect with sql talk, the error i get returned is ora-03121 - no interface driver connected.
The database is called casper and the instance devl. I've loaded sql net v2.2 as I believe 2.3 is 32 bit only and I'm running tcp/ip.
I'm using the following connect string in sql.ini
[oragtwy]
remotedbname=casper,_at_casper.world
longbuffer=32760
fetchrow=20
maperror=OFF
substitute=SYSSQL.,
and this is my tnsnames.ora
casper.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = oracle.intranet)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = oracle.intranet)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
but it doesn't work and it's winter and it's pouring down with rain...
Should I
- throw myself under a bus?
- throw sql windows under a bus?
- throw a bus at sql net?
ps. I can connect to Oracle using sql plus.
Any suggestions (constructive) comments appreciated....
Thanks
Jeremy Cope
IntraHealth Systems Limited
Auckland
New Zealand
Received on Mon Jul 14 1997 - 00:00:00 CEST