Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    62

    Unanswered: Oracle client for 64 bit SSIS

    Hi,

    I am currently migrating a database to a new 64 bit windows server from a 32 bit windows server. One of my SSIS packages connects to an Oracle datbase using the ADO NET connection manager and the OracleClient Data provider. On the 32 bit server, we have an Oracle 10g express client installed.

    I need to install a similar client on the new 64 bit box, but i can't seem to find the express client for 64 bit. Does anyone know if it exists? Is it ok to use the 11g client instead for 64 bit?

    thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    The 11g client should be fine to connect to a 10g Express database. The express version of Oracle only affects the capabilities of the database, I do not think there are many limitations on the client side. Also, I do not believe the client connectivity files are licensed. As always, copious testing should be done.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •