Re: Win98 and Oracle8 Questions - more info

I finally was able to get connected from my Win98 Client machine with SQLPLus to my OracleNt Server (problem with tnsnames.ora). However, I am getting the following error in VisualBasic from the same client machine.

ORA-12203: TNS:unable to connect to destination Cause: Invalid TNS address supplied or destination is not listening. This error can also occur because of underlying network transport problems. Action: Verify that the service name you entered on the command line was correct. Ensure that the listener is running at the remote node and that the ADDRESS parameters specified in TNSNAMES.ORA are correct. Finally, check that all Interchanges needed to make the connection are up and running.

The VB code that I am executing is: The error is on the OraSession.dbOpendDatabase

Dim OraSession As Object
 Dim OraDatabase As Object
 Dim OraDynaset As Object

 'Create the OraSession Object.
 Set OraSession = CreateObject("OracleInProcServer.XOraSession")

 'Create the OraDatabase Object by opening a connection to Oracle. Set OraDatabase = OraSession.DbOpenDatabase("PONYSERVER", "system/manager", 0&)

In article <7e3g4d$70f$1_at_nnrp1.dejanews.com>,   garysadler_at_my-dejanews.com wrote:
> You'll need Oracle Client 8.0.5 or 8.1.5 for Win98 compatibility.
>
> In article <7e31iv$prn$1_at_nnrp1.dejanews.com>,
> pony8030_at_my-dejanews.com wrote:
> > Hopefully this is a simple answer since I am new to Oracle8. But it appears
> > that some people are haveing trouble with Win98 and Oracle Tools. Something
> > about Net8 is not compatible and I have to use SQLNet2.3. I've installed
both
> > and thought that I have configured both correctly on my Win98 machine. Not
> > positive but probably correct. But whenever I try to run a Oracle Tool and
> > connect to my server the tool crashes.
> >
> > My basic goal is to get a connection from a Win98 to an NT Oracle server to
> > produce a small vb sample application? Would like to hit the Oracle server
> > with ERwin as well.
> >
> > Question: Are any of the Oracle tools supported under Win98?
> > What network files need to be modified to make the connection to the
server?
> >
> > Question: Can I still access the Oracle database from VBasic using ADO
under
> > Win98?
> > What do I need to configure to get this connection?
> >
> > Question: Is the Oracle ODBC driver compatible, whenever I try to create a
> > data source for it, it tells me that the specified driver could not be
loaded
> > 1157?
> >
> > Question: Does the Microsoft Oracle ODBC driver work under Win98?
> >
> > Question: Is the connect string in SQLPlus the sid on the Oracle Server,
where
> > does it look for to translate to an actual Oracle Server?
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Apr 03 1999 - 14:46:22 CST