Link to Oracle database

Hi all,
I have installed Oracle client tool on the SQL server and have checked the tns file. Everythings look fine, even from the server I can run SQL Plus and connect to the Oracle database. When I create a link and try to refresh tables under linked serve, I ge
t this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.8, but I get the same error.
Any help would be appreciated.
Shahri
That's a generic error. Try turning on trace flag 7300 or
us SQL Profiler to capture the OLEDB Errors event. This
should give you to get more information about the error.
Additionally, you'll want to check the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 16 Jun 2004 08:43:37 -0700, Shahri
<Shahri@.discussions.microsoft.com> wrote:

>Hi all,
>I have installed Oracle client tool on the SQL server and have checked the tns file. Everythings look fine, even from the server I can run SQL Plus and connect to the Oracle database. When I create a link and try to refresh tables under linked serve, I g
et this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.8, but I get the same error.
>Any help would be appreciated.
>Shahri

Link to Oracle database

Hi all,
I have installed Oracle client tool on the SQL server and have checked the t
ns file. Everythings look fine, even from the server I can run SQL Plus and
connect to the Oracle database. When I create a link and try to refresh tabl
es under linked serve, I ge
t this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I rein
stalled MDAC 2.8, but I get the same error.
Any help would be appreciated.
ShahriThat's a generic error. Try turning on trace flag 7300 or
us SQL Profiler to capture the OLEDB Errors event. This
should give you to get more information about the error.
Additionally, you'll want to check the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 16 Jun 2004 08:43:37 -0700, Shahri
<Shahri@.discussions.microsoft.com> wrote:

>Hi all,
>I have installed Oracle client tool on the SQL server and have checked the tns file
. Everythings look fine, even from the server I can run SQL Plus and connect to the
Oracle database. When I create a link and try to refresh tables under linked serve,
I g
et this error: Error 7399:OLE DB provider 'MSDAORA' reported an error. I reinstalled MDAC 2.
8, but I get the same error.
>Any help would be appreciated.
>Shahri

limitations, compatibility

Hi,
What are the limitations of using the automated conversion tool and how to deal with compatability issues?
Thanks

I assume the automated conversion tool you refer to is the DTS to SSIS migration tool? Not a big fan, I often think it is easier to stick with DTS until you have a need and/or the time to re-write using SSIS to the full, rather than the shortcuts the migration tool takes.

Try some of these references-

Upgrading DTS
(http://wiki.sqlis.com/default.aspx/SQLISWiki/UpgradingDTS.html)