ASP.NET, SQL Server, WPF, C#, VB.NET

Hello all, 
 
Windows Server 2003 (Enterprise) 
 
AMD64 (Opeteron) 
 
SQL 2005 
 
Oracle 9i 
 
Please help. We are running SQL Server 2005 64bit on an Windows 2003 
 
Server Machine using AMD Opteron Processors. We are trying to setup 
 
linked servers to some Oracle 9i Databases on 32bit servers. We need 
 
to install ODBC/OLEDB providers for Oracle to achieve  this. we are 
 
having difficulty finding out a few things : 
 
i. How to install Microsoft OLEDB for Oracle - we have MDAC 2.8 
 
installed, but still there is no provider. The question is what is the 
 
correct OLEDB provider and how do we get it and is there such a thing 
 
as 64bit MDAC ? 
 
ii. All literature suggests that 64bit version of these products are 
 
only available on Itanium 2 or higher processors. Is there any way to 
 
utilise these technologies on 64 bit Opteron. 
 
Your help would be much appreciated as we are at our wits end for what 
 
is turning out to be quite an expensive project (we are hiring the 
 
64bit server). 
 
We currently have Linked servers configured on Win2003 (32bit) server 
 
and SQL 2000.  These use "Microsoft OLEDB Provider for Oracle".  Is 
 
this provider available for AMD64 architecture and if so where can we 
 
get it? 
 
Thanks in advance. 
 
Dave

Hi Brent, 
 
Thanks for your response.  A few more questions if you don't mind... 
 
Are you using 'Linked Servers' within SQL2005 to access your remote 
 
Oracle data?  If so which Provider are you selected from the drop down 
 
list in the 'New Linked Server' dialog box. 
 
I've downloaded the files you suggeste which installs the Oracle OLEDB 
 
provider but MS state you need to have "Microsoft OLEDB provider for 
 
Oracle" in order to use Linked servers. 
 
Struggling on but am starting to think we may have to come up with and 
 
intermediate 32bit SQL server to host the connection to Oracle. 
 
Regards 
 
Dave 
 
On Thu, 3 Aug 2006 21:25:33 -0400, "Admiral Q" 
 
<Star_Fleet_Admiral_Q(No-Spam-Man)@(Can-the-Spam)hotmail.com> wrote: