How to query oracle DB from SQL Server 2008 x64 ?

Home Forums Other Microsoft Servers and SaaS SQL Server 2005 / 2008 / 2008 R2 / 2012 / 2016 How to query oracle DB from SQL Server 2008 x64 ?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Avatar
    albertwt
    Member
    #153875

    Hi Everyone,

    I’m having difficulties in creating a connection from my SQL Server 2008 Enterprise SP2 x64 into the Oracle database 10g even though I have already install the Oracle Client 11g R2 ?

    I’ve followed this article from steps URL: http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/

    plus added: TNS_ADMIN into the Server variables which point into: C:Oracleproduct11.2.0client_1networkadmin

    what is working now:

    TNSNAMES.ORA has been copied successfully from the other Developer wworkstation
    i can TNSPING into the DB instance
    i can connect to the database using SQLplus and perform any SQL commands
    i can create the DSN ONLY when using “C:WindowsSysWOW64odbcad32.exe” the normal odbcad32.exe doesn’t show my DSN that I have just created ?
    the DSN created from the above works fine from the test connection.

    my goal: To be able to select the Oracle connection in the Linked server object but still no effect after I restart the server. (Windows Server 2008 Enterprise 64 bit SP2).

    Any idea please in resolving this problem would be greatly appreciated.

    Thanks.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.