RE: 2005 cluster can't find Oracle client or local system OOBC

Hello Fidelr,

I understand that you are not able to connect to Oracle DB via SQL 2005
SSIS. If it is not correct, please let me know.

As far as I know, Microsoft provides neither Oracle 64-bit ODBC driver nor
Oracle 64-bit OLE-DB provider. You may refer to the following article for
some more related information:

http://msdn2.microsoft.com/en-us/library/ms141766.aspx


As for the issue that .Net Providers\Odbc data provider cannot work with
Oracle ODBC driver, it seems to be compatiblilty issue. You may want to
contact Oracle to see if they have updated version of ODBC driver or 64 bit
OLEDB provider (64 bit) included in Oracle 64 bit client tool. As I know,
Oracle seems have the fix for some known issues.

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs
/10201winx64soft.html


The following are some links that you shall be interested in:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=159581&SiteID=1

http://groups.google.com/group/microsoft.public.data.odbc/browse_thread/thre
ad/aa40b644abbaa0b9/91834f0a29290aff?lnk=st&q=&rnum=1&hl=en#91834f0a29290aff


If anything is unclear or you have concerns, please feel free to let's
know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... communicate back through IIS to SQL*NET installed for the Oracle Client. ... Microsoft SQL Server 2000 Standard with SP3a installed on same box. ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.iis)
  • Re: ORACLE CLIENT USERS BEWARE: Bug in Query Builder breaks SQL
    ... For what it's worth, none of this surprises me; Microsoft create all kinds of "providers" based on fashions and fads of the day, the press release reads "fully supports Oracle", then they lose interest and you are stuck with something that doesn't work anymore. ... Comparing the Microsoft .NET Framework 1.1 Data Provider for Oracle and the Oracle Data Provider for .NET ... When trying to use the Query Builder with Oracle, queries that create INNER JOIN syntax result in an error in Query Builder when trying to generate your schemas. ...
    (microsoft.public.vsnet.general)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... "Oracle may provide additional releases or versions of its programs ... in the form of an Update as part of our technical support services. ... cucumber vendor that insisted I could only buy cucumbers from them, ... If I have the source code, I know I can relly on a product for ever, ...
    (comp.lang.php)
  • RE: Linux sucks?
    ... > Microsoft, they wont charge you. ... I run Oracle 9i RAC on a linux cluster at work, ... regardless of the level of support. ...
    (Fedora)