help with sqlwindows and oracle 7.3 connectivity

From: Jeremy Cope <jeremy_at_intrahealth.co.nz>
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

  1. throw myself under a bus?
  2. throw sql windows under a bus?
  3. 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

Original text of this message