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.
>
>.
>

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[vbcol=seagreen]
>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...
Oracle[vbcol=seagreen]
with[vbcol=seagreen]
bit.[vbcol=seagreen]
this?
>
>.
>

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...
Oracle[vbcol=seagreen]
with[vbcol=seagreen]
bit.[vbcol=seagreen]
this?[vbcol=seagreen]
>
>.
>sql

server Trouble to Oracle

I'm currently trying to establish a linked server to an Oracle
database.

Setup:
Connecting to 8x version of Oracle
Using 9i client tools (Net Manager)
SQL-Server 2000
Windows 2000

I installed the Oracle 9i client tools, and set up a Service for the
Oracle connection. Testing from the 9i client produces a successfull
connection.

I then opened SQL-Server and created a new Linked Server with the
following setup:

Name - PYR_Link
Provider - Microsoft OLE DB Provider for Oracle
Product Name - PYR
Data Source - PYR (9i Service Name)
Provider string - MSDAORA

I get the unspecific 7399 error that OLE DB provider MSDAORA reported
an error, trace 'Initialize returned 0x80004005'

I've searched through the archives, checked all of the relevant
Microsoft articles I could find, and still have no idea what is wrong.
SQL-Server reports that the provider is registered in the system, but I
can't figure out what I'm missing.

Help or a guide for troubleshooting would be much appreciated.

TimAn update - When I run sp_catalog in Query Analyzer, the error message
is more detailed. It says the provider could nor resolve the service
name. Still strange, considering the Net Manager client connects fine.|||Hi Tim, this error could occur when the oracle domain is not recognised.

Try to find out the Oracle domain (e.g. 'world') and change your linked
server to connect to that domain, like product name PYR.world and data
source PYR.world.

Good luck!
Maurits

<tim.pascoe@.cciw.ca> schreef in bericht
news:1123770210.158827.38320@.g47g2000cwa.googlegro ups.com...
> I'm currently trying to establish a linked server to an Oracle
> database.
> Setup:
> Connecting to 8x version of Oracle
> Using 9i client tools (Net Manager)
> SQL-Server 2000
> Windows 2000
> I installed the Oracle 9i client tools, and set up a Service for the
> Oracle connection. Testing from the 9i client produces a successfull
> connection.
> I then opened SQL-Server and created a new Linked Server with the
> following setup:
> Name - PYR_Link
> Provider - Microsoft OLE DB Provider for Oracle
> Product Name - PYR
> Data Source - PYR (9i Service Name)
> Provider string - MSDAORA
> I get the unspecific 7399 error that OLE DB provider MSDAORA reported
> an error, trace 'Initialize returned 0x80004005'
> I've searched through the archives, checked all of the relevant
> Microsoft articles I could find, and still have no idea what is wrong.
> SQL-Server reports that the provider is registered in the system, but I
> can't figure out what I'm missing.
> Help or a guide for troubleshooting would be much appreciated.
> Tim