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

Jim Lawrence (AccessD) accessd at shaw.ca
Wed Oct 27 17:17:41 CDT 2004


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




More information about the dba-SQLServer mailing list