[dba-SQLServer] connecting to oracle from SQL Query Analyzer

Thanks Jim.  The 4th article was most helpful.

I was working with Oracle 8.  Could not install oracle client from CD.  As 
it turns out, there is an issue that prevents oracle 8 from being installed 
on a P4 system.  There is a patch avaliable for this; the alternate solution 
was to copy contents of cd to local disk and rename one of its files; then 
only then was I able to install the oracle client.  This issue was fixed in 
Oracle 9.

Billy

>From: "Jim Lawrence (AccessD)" <accessd at shaw.ca>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] connecting to oracle from SQL Query Analyzer
>Date: Wed, 27 Oct 2004 15:17:41 -0700
>
>Billy:
>
>PS check out the previous three articles for full details.
>1. http://databasejournal.com/article.php/3085211
>2. http://databasejournal.com/article.php/3103331
>3. http://databasejournal.com/article.php/3116011
>as well as the one I sent you:
>4. http://databasejournal.com/features/mssql/article.php/3290801
>
>HTH
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Billy
>Pang
>Sent: Wednesday, October 27, 2004 1:32 PM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer] connecting to oracle from SQL Query Analyzer
>
>
>Hello:
>
>I want to be able to connect to an Oracle database (version 8.1.x 
>preferred)
>from SQL Query Analyzer.  Any ideas?  I tried using a linked server but I
>get the following error message when I try to query the oracle db.
>
>Server: Msg 7399, Level 16, State 1, Line 1
>OLE DB provider 'MSDAORA' reported an error.
>[OLE/DB provider returned message: Oracle error occurred, but error message
>could not be retrieved from Oracle.]
>
>I already have the oracle client sw installed on my machine and am able to
>query oracle from an oracle client but for some strange reason it is not
>working from QA.
>
>thanks in advance.
>
>Billy
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>