64 bit windows 2003 sp2 SQL SERVER 2005 Linked server

The server is IBM XS 466.
The server is Windows 2003 R2 64 bit with SQL 2005 SP2 Enterprise Edition
(64bit),I want to create a linked server for Oracle,I have installed ORACLE
Client 10g(64bit) ,but I can't find any drivers about oracle in SQL SERVER
2005,i can't find 'MSDAORA',it caust i can't create linked server for
oracle.msbut I can find some drivers about oracle in ODBC,but must run
'c:\windows\system32\odbcad32.exe'
This proble puzzle me for some days
--
Standing on Shoulders of Giants* fds2003 wrote, On 4-7-2007 12:32:
> The server is IBM XS 466.
> The server is Windows 2003 R2 64 bit with SQL 2005 SP2 Enterprise Edition
> (64bit),I want to create a linked server for Oracle,I have installed ORACLE
> Client 10g(64bit) ,but I can't find any drivers about oracle in SQL SERVER
> 2005,i can't find 'MSDAORA',it caust i can't create linked server for
> oracle.msbut I can find some drivers about oracle in ODBC,but must run
> 'c:\windows\system32\odbcad32.exe'
> This proble puzzle me for some days
My first guess is that the 64 version of SQL Server can only load 64-bit
drivers. This means the old OleDb driver and ODBC driver are not
compatible.
Either reinstall SQL server as 32-bit binaries or find a 64-bit
compatible driver for Oracle.
Jesse|||* fds2003 wrote, On 4-7-2007 12:32:
> The server is IBM XS 466.
> The server is Windows 2003 R2 64 bit with SQL 2005 SP2 Enterprise Edition
> (64bit),I want to create a linked server for Oracle,I have installed ORACLE
> Client 10g(64bit) ,but I can't find any drivers about oracle in SQL SERVER
> 2005,i can't find 'MSDAORA',it caust i can't create linked server for
> oracle.msbut I can find some drivers about oracle in ODBC,but must run
> 'c:\windows\system32\odbcad32.exe'
> This proble puzzle me for some days
You can find the 64-bit OleDB Driver here:
http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html
That should get things in working order.
Jesse|||I haved installed 64bit Driver for Oracle,but the proble is the same,it has
other approach?
--
Standing on Shoulders of Giants
"Jesse Houwing" wrote:
> * fds2003 wrote, On 4-7-2007 12:32:
> > The server is IBM XS 466.
> > The server is Windows 2003 R2 64 bit with SQL 2005 SP2 Enterprise Edition
> > (64bit),I want to create a linked server for Oracle,I have installed ORACLE
> > Client 10g(64bit) ,but I can't find any drivers about oracle in SQL SERVER
> > 2005,i can't find 'MSDAORA',it caust i can't create linked server for
> > oracle.msbut I can find some drivers about oracle in ODBC,but must run
> > 'c:\windows\system32\odbcad32.exe'
> > This proble puzzle me for some days
> You can find the 64-bit OleDB Driver here:
> http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html
> That should get things in working order.
> Jesse
>