Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2003
    Location
    Sweden, Stockholm
    Posts
    14

    Exclamation Unanswered: Oracle odbc driver on windows 2003 64 bit SQL Server 2005

    God morning!
    I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases.
    - I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange!
    - I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data sources! Neither the oledb under providers in MSS Manager Studio!
    - Same result efter several desintall and installation. A college copied the .dll files och run a script to register the dll files. We could then se the Oracle driver in the Database sources, but we could not create any connection.
    - We have even tried an 10G version of Oracle with the same result.

    Is there anyone who succeeded installing Oracle on 64 bit Windows and could create odbc connection/linked server?

    Regards
    Last edited by fari.sah; 10-24-06 at 03:23.
    /*
    Fari Sah
    */

Posting Permissions

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