Re: Connecting to Personal Oracle 7 via ODBC

Choong Chong Yew wrote:
>
> Hi!
>
> I've spent like about 5-6 hours trying to connect to Personal Oracle 7 for
> Windows 95 via ODBC but I'm still unsuccessful.
>
> The database alias was created using SQL*Net, and the connect string
> parameter in the ODBC setup was typed in correctly according to the help
> file but everytime I try to connect from MS-Access, I get the "connection
> failed" error!
>
> What could be wrong???

Choong:

This is a bug in the latest verion of the ODBC. We had to revert to an older version of the ODBC to ensure that it was working. The version information is as follows

	TCP/IP 1.1.9.0A
	SQLNET	2.1.4.1.4
	TCP/IP adapter	2.1.4.1.3a
	ODBC Driver 1.11.0.5, 1.11.1.5

We had tried the 32bit ODBC connection under Win95 and were unsuccessful.

I am not aware of any patch.

Note: the latest and greatest TCP/IP and SQL*NET and SQL*Plus work fine. The problem appears to be isolated to the ODBC connection.

We got the old drives by downloading the trial version of Oracle for NT. We only installed the SQL TCP/IP and ODBC from that package. The newest version of the SQL*PLUS works with those SQL*Net stuff.

Mike Krolewski Received on Thu Jul 11 1996 - 00:00:00 CEST