Re: Help: Pers Oracle, ODBC, Win95

In win95, you need sqlnet client installed for odbc to work. I made it work this way. For connect string, it doesn't matter if you use 2: or leave it blank. Jan is right, in OS/2 you need 2: but not necessary in win95.

Victor Tsien

Jonathan Gennick wrote:

> I am trying to open an ODBC connection to the Personal
> Oracle database on my Windows 95 machine, but can't. I have
> had Personal Oracle running for some time and can
> succussfully connect via SQL*Plus by using:
>
> user-id: SYSTEM
> password: MANAGER
> host string: <blank>
>
> I created an ODBC data source as follows:
>
> name: Personal
> Description: Personal
> SQL*Net
> Connect String: 2:
>
> When I run ODBC-Test and try to connect using the above data
> source, I get a dialoge box with the following error:
>
> SQLSTATE: 08003
> Native Error Code: 0
> Driver Message: [Oracle][ODBC Oracle Driver]Connection
> not open.
>
> After dismissing that dialogue, I get another as follows:
>
> SQLSTATE: 01000
> Native Error Code: 0
> Driver Message: [Microsoft][ODBC Driver Manager]The
> driver returned invalid (or failed to return)
> SQL_DRIVER_ODBC_VER: %s
>
> I'm really flummoxed here. Why can't I connect? I am using
> Personal Oracle 7.3.2.2. The ODBC driver came with it and is
> version 1.15.3.1.0A. I am using the 32-bit version.
>
> Help!
>
> Jonathan
>
>
> -----------------------------------
> Jonathan Gennick
> gennick_at_worldnet.att.net
> "Brighten the Corner Where you Are"
Received on Tue Sep 02 1997 - 00:00:00 CDT