Oracle connection from a SQL2005 Ent. Edt. X64 cluster

Hi
Does anybody know if there is a problem/issue with retrieving data from
Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
the MSDAORA provider like I have on my other servers.
I don't recall having ever seen this not being present in a SQL
installation, so I'm wondering if this has something to do with the fact
that it's a Cluster install?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> Hi
> Does anybody know if there is a problem/issue with retrieving data from
> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have the
> MSDAORA provider like I have on my other servers.
> I don't recall having ever seen this not being present in a SQL
> installation, so I'm wondering if this has something to do with the fact
> that it's a Cluster install?
>
There is no 64bit version of the MSDAORA provider. You will need the OleDB
Provider from Oracle. Get version 10.2.0.2.
David|||David Browne wrote:
>
> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data
>> from Oracle on a SQL2005 Cluster? My problem is that I don't seems to
>> have the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the
>> fact that it's a Cluster install?
> There is no 64bit version of the MSDAORA provider. You will need the
> OleDB Provider from Oracle. Get version 10.2.0.2.
> David
Hi David,
Thanks for the info. I'll try to get it working with the Oracle OLEDB
provider. I've never used that one, so do you by any change have any
links that tells about how to install/configure it?
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote in
message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
> David Browne wrote:
>>
>> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
>> in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data from
>> Oracle on a SQL2005 Cluster? My problem is that I don't seems to have
>> the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the fact
>> that it's a Cluster install?
>>
>> There is no 64bit version of the MSDAORA provider. You will need the
>> OleDB Provider from Oracle. Get version 10.2.0.2.
>> David
> Hi David,
> Thanks for the info. I'll try to get it working with the Oracle OLEDB
> provider. I've never used that one, so do you by any change have any links
> that tells about how to install/configure it?
>
Oracle Provider for OLE DB
http://www.oracle.com/technology/tech/windows/ole_db/index.html
David|||David Browne wrote:
>
> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk> wrote
> in message news:e1CkGmMYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> David Browne wrote:
>>
>> ""Steen Schlüter Persson (DK)"" <steen@.REMOVE_THIS_asavaenget.dk>
>> wrote in message news:uAWzvoJYHHA.4232@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> Does anybody know if there is a problem/issue with retrieving data
>> from Oracle on a SQL2005 Cluster? My problem is that I don't seems
>> to have the MSDAORA provider like I have on my other servers.
>> I don't recall having ever seen this not being present in a SQL
>> installation, so I'm wondering if this has something to do with the
>> fact that it's a Cluster install?
>>
>> There is no 64bit version of the MSDAORA provider. You will need the
>> OleDB Provider from Oracle. Get version 10.2.0.2.
>> David
>> Hi David,
>> Thanks for the info. I'll try to get it working with the Oracle OLEDB
>> provider. I've never used that one, so do you by any change have any
>> links that tells about how to install/configure it?
> Oracle Provider for OLE DB
> http://www.oracle.com/technology/tech/windows/ole_db/index.html
> David
>
Thanks David - I'll give it a try.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator