Re: ODBC Drivers For Oracle7

In article <CM1oG3.44n_at_csc.ti.com>, anturner_at_sc1500.dseg.ti.com (Alan N Turner) writes:
> I've been trying to find any ODBC drivers for Oracle7. Microsoft
> disavows any knowledge of Oracle7. They say their ODBC drivers
> support Oracle 6 only.

In fact, their Oracle driver works relatively well with Oracle7 as long as you don't want to use any features which were introduced in Oracle7. Also, I wouldn't bet my business on its reliability (it's from Microsoft, after all). But for short-term, non-critical use, you might want to give it a try.

> I have found an Oracle7 ODBC driver on CompuServe, but it's from
> PageAhead.
>
> Conversations with Oracle Corp. (when you can get one) are absolutely
> mind-boggling. First, they say there are no ODBC drivers yet ready
> for Oracle7 and when they are ready, they'll cost you extra, even if
> you spent mega-bucks on their DBMS.

Yes. They are planning to treat it like any other add-on product, like SQL*Net. It is tentatively planned to be distributed as part of some sort of connectivity package, although this is not firmly decided.

> Second, they tried to sell us Oracle Glue instead, for a mere $3,000.

I've been told by Oracle users that Glue is faster than ODBC (surprise!).

> The next comment was that the
> Oracle7 ODBC drivers were in Oracle Glue. What! You just said the
> ODBC drivers weren't ready.
>
> It sure seems like the inmates are running the asylum out in
> Redwood Shores.

Yes.

> Cheers,
>
> Alan 'The comments and opinions presented
> Sr. Strategy DBA are mine and do not necessarily reflect
> Systems And Equipment Sector those of Texas Instruments, Inc. or its
> Texas Instruments subsidiaries.'
> anturner_at_sc1500.dseg.ti.com

Q+E Software (800-876-3101) sells an ODBC driver pack for $199 which includes drivers for Oracle 6 and Oracle7, not to mention Sybase, Ingres, Paradox, and half a dozen more. The Q+E drivers I've used are pretty good, although I've had several problems with their Sybase/SQL Server driver.

Please note that I don't work for Oracle or Q+E, nor do I speak in any official capacity for either one. I'm just trying to be helpful.

-- 
The above statements are not the opinions or policies of SPSS Inc.
The above statements may not be the opinions of Brent Lambert.
The first disclaimer is a policy of SPSS Inc.
Subsequent disclaimers are probably the opinion of Brent Lambert.