servers on SQL 2000 64 bit

Is it possible to set up a linked server in SQL Server
2000 64 bit to Oracle? I installed the 64 bit version of
the Oracle Provider for OLEDB and was able to set up a
linked server to point to it. I can retrieve the table
listing okay when I click on it in Enterprise Manager;
however, I receive the following error when I try to do
anything over the link - "Provider caused a server fault
in an external process."
From what I can tell, Microsoft supports linking to Oracle
using the Microsoft OLEDB Provider for Oracle or the
Microsoft OLEDB Provider for ODBC - the only problem with
this is it looks like these have not been ported to 64 bit.
Has anyone had any luck trying to do something like this?
Thanks for your help.EM is still a 32 bit app and might have issues dealing directly with a 64bit
Linked Server. How does it work through QA?
--
Andrew J. Kelly SQL MVP
"Jason Brenson" <jbrenson@.hycite.com> wrote in message
news:038e01c470d8$e28aa380$3a01280a@.phx.gbl...
> Is it possible to set up a linked server in SQL Server
> 2000 64 bit to Oracle? I installed the 64 bit version of
> the Oracle Provider for OLEDB and was able to set up a
> linked server to point to it. I can retrieve the table
> listing okay when I click on it in Enterprise Manager;
> however, I receive the following error when I try to do
> anything over the link - "Provider caused a server fault
> in an external process."
> From what I can tell, Microsoft supports linking to Oracle
> using the Microsoft OLEDB Provider for Oracle or the
> Microsoft OLEDB Provider for ODBC - the only problem with
> this is it looks like these have not been ported to 64 bit.
> Has anyone had any luck trying to do something like this?
> Thanks for your help.|||Andrew-
I have linked the server through QA and Enterprise
Manager - I get the OLEDB error when I try running a query
against the remote oracle database using QA. The Oracle 64
bit connection from the server works fine using Oracle's
SQL Plus Worksheet.
The Oracle Provider for OLEDB driver doesn't seem to work
very well on a 32 bit SQL server either - I can only get
consistent results using the Microsoft OLEDB Provider for
Oracle.
>--Original Message--
>EM is still a 32 bit app and might have issues dealing
directly with a 64bit
>Linked Server. How does it work through QA?
>--
>Andrew J. Kelly SQL MVP
>
>"Jason Brenson" <jbrenson@.hycite.com> wrote in message
>news:038e01c470d8$e28aa380$3a01280a@.phx.gbl...
>> Is it possible to set up a linked server in SQL Server
>> 2000 64 bit to Oracle? I installed the 64 bit version of
>> the Oracle Provider for OLEDB and was able to set up a
>> linked server to point to it. I can retrieve the table
>> listing okay when I click on it in Enterprise Manager;
>> however, I receive the following error when I try to do
>> anything over the link - "Provider caused a server fault
>> in an external process."
>> From what I can tell, Microsoft supports linking to
Oracle
>> using the Microsoft OLEDB Provider for Oracle or the
>> Microsoft OLEDB Provider for ODBC - the only problem
with
>> this is it looks like these have not been ported to 64
bit.
>> Has anyone had any luck trying to do something like
this?
>> Thanks for your help.
>
>.
>