471,873 Members | 1,728 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

Unable to initialize OraOLEDB from SQL Server 2005 x64 to Oracle

I have a 64 bit SQL Server 2005 SP2 on a Windows 2003 x64. The
developer said that he needed to use OLE to talk to Oracle so I went
to Oracle and downloaded the 64 bit OraOLDDB driver as recommended in
a MS note.

I can connect to Oracle via tnsping and using SQLPlus but I cannot
create a linked db successfully.

The linked database errors off with >Cannot initialize data source
for OLE provider "OraOLEDB.Oracle" for Lined Server "X" (Microsoft SQL
Server error: 7399) << (manually typed)

Here is the official OS, SQL Server, and Oracle client information:

The OS is Windows Server 2003 Standard x64 edition Service Pack 2
(NT 5.2 build 3790)

The SQL Server 2005 9.0.3042 (x64)
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.3959
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790

The OraOLEDB.Oracle driver was installed from the Oracle 64 bit
download with a database version of

Oracle "tnsping sid " works
SQLPlus (ver 9.2) works

I have serveral linked databases to Oracle that I have built but all
of them are 1- on SQL Server 2000 and 2- are 32 bit. If anyone knows
of any additional patches (Windows or Oracle) necessary to resolve
this I would appreciate the information. Also there are potential
firewall issues though the fact that SQLPus can be used seems to rule
this out, but if there are any ports associated with OLE I would like
to check on them specifically.

-- Mark D Powell --

Nov 12 '07 #1
0 2272

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Richard | last post: by
1 post views Thread by Brian Conway | last post: by
1 post views Thread by Randy Harris | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.