Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Oracle linked Server

 
   Database Help (Home) -> Connect RSS
Next:  Database Design  
Author Message
Aaron M. Lowe

External


Since: Feb 05, 2004
Posts: 1



(Msg. 1) Posted: Thu Feb 10, 2005 4:31 pm
Post subject: Oracle linked Server
Archived from groups: microsoft>public>sqlserver>connect (more info?)

Hello,

I have a SQL 2003 SP3a on Windows 2003 and am connecting to an Oracle 9i
database.

I've set up the linked server and necessary permissions and it has been
working successfully for months. However occasionally after rebooting the
machine I receive this message when attempting a query from the linked
server:

Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle client and networking components
were not found. These components are supplied by Oracle Corporation and are
part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005: ].

I can still connect successfully through either Oracle Net Configuration
Assistant or an ODBC DSN and the only way I know how to solve this is by
stopping and restarting the SQL Server instance. The only thing I can think
of is that during server startup, the SQL Service gets started before the
oracle service starts, and somehow SQL caches this connection.

Has anyone experienced this? If so, what's the best way to deal with this
without stopping the server?

Thank you,

Aaron Lowe

 >> Stay informed about: Oracle linked Server 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Performanceproblem with subquery to Oracle Linked Server - Hello I hope anyone can help me here with a Problem between my Microsoft SQL Server 2000 SP 3 and an Oracle 8 Server. I have to copy records from a Oracle table (3.000.000 records by now) to a SQL Server table (8.000.000 records by now) daily..

Linked Server Connection and CONCAT_NULL_YIELDS_NULL - Hello I have question to linked Server Connection from a SQL2k Server to another SQL2k Server. I set up the linked server Connection with the command: EXEC sp_addlinkedserver @server='NEST', @srvproduct='', @provider='SQLOLEDB', @datasrc='ISAG2' The...

IIS 6 and Windows Authentication to SQL Server 2000 - I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server...

Cannot connect to local sql server 2000 from VB.NET on pc .. - Hi I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC. When I run the following VB.NET code: Protected Const SQL_CONNECTION_STRING As String = _ "Server=localhost;" & _ "DataBase=Northwind;" &...

automating server registration - I'm forever running around updating\ change client libraries and aliases on developer machines. Has anyone any idea how I could go about automating this eg User logs in to the network and automatically their server aliases are updated\ corrected with...
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]