Anita,
Thanks for the suggestion. Yes, I did have tnsnames.ora files in the database
directory and the Oracle Enterprise Manager directory. I renamed all of them
except the one in the pfile directory.
I received a "special" dll file from a contact at Microsoft and I placed it
into the common dll directory in Windows 2000. But Windows 2000 prevents a user
from changing the operating system. As soon as I put the dll into the system,
Windows 2000 changed it back to the old version.
I'm supposed to talk to the contact tomorrow.
Tom Harleman
11080 Willowmere Dr.
Indianapolis, IN 46280
317-844-2884 Home
317-843-9122 Home Office
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of A. Bardeen
Sent: Wednesday, June 21, 2000 8:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Connectivity Oracle 8i and SQL Server 7.0
Tom,
Do you have multiple tnsnames.ora's on your system?
It sounds like the one that MS is using doesn't have
the alias you're using, or the file doesn't exist at
all, whereas the one that gets used by SQL*Plus does.
You might also check the sqlnet.ora's to make sure the
default.domain's are the same.
HTH,
- Anita
- tharleman_at_iquest.net wrote:
> I'm trying to connect SQL Server to Oracle 8i.
> I realize this is more of a Microsoft issue, but
> hopefully someone here has
> experienced this, also.
>
> I'm using Microsoft Enterprise Manager to create a
> Linked Server to Oracle 8i.
> I'm using the MS OLE DB Provider for Oracle that is
> included in SQL Server 7.0.
>
>
> After creating the link when I try to view the
> tables, I get an alert dialog
> that reads, "Error 7399: OLE DB provider 'MSDAORA'
> reported an error."
>
> When I try to use the link in SQL Server Query
> Analyzer, I get the message,
>
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDAORA' reported an error.
> [OLE/DB provider returned message: ORA-12154:
> TNS:could not resolve service]
>
>
> However, I CAN connect to the database using
> SQL*Plus from the server and the
> client computers.
>
> I checked the TNSNAMES.ORA file and it appears to be
> correct.
>
> Does anyone have any suggestions about where I
> should start looking?
>
> I did find an article at
>
support.microsoft.com/support/kb/articles/Q244/6/61.asp
> entitled, "INFO: Microsoft Oracle ODBC Driver and
> Provider Support Connectivity
> to Oracle 8i"
>
> It says that the drivers "that are released with
> MDAC 2.5 have been tested and
> support connectivity to Oracle 8i. None of the
> earlier versions of this driver
> and the provider support this behavior."
>
> Is it ORACLE or MICROSOFT?
>
> Tom Harleman
> 11080 Willowmere Dr.
> Indianapolis, IN 46280
> 317-844-2884 Home
> 317-843-9122 Home Office
>
>
> --
> Author:
> INET: tharleman_at_iquest.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Send instant messages with Yahoo! Messenger.
http://im.yahoo.com/
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
Received on Thu Jun 22 2000 - 06:44:28 CDT
