SQL Server ODBC driver for Linux

  • Hoping someone has experience with this. I'm trying to set up a database link from my Oracle on Linux database to my SQL Server 2005 instances. Research shows that I need a SQL Server ODBC driver on the Linux box (duh), my questions are:

    1a. Does anyone have suggestions on which driver to use? It appears that I have to pay for all/most of them.

    1b. Anyone ever used TDS (www.freetds.org) for this implementation?

    2. Has anyone set this up, maybe provide a link to something fairly terse? The Oracle documentation is very wordy and doesn't specifically lay out the solution.

    TIA.

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • Found an answer for question number 2:

    https://metalink2.oracle.com/metalink/plsql/f?p=130:14:2551972738979005909::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,466228.1,1,0,1,helvetica

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • dh (6/22/2009)


    Found an answer for question number 2:

    https://metalink2.oracle.com/metalink/plsql/f?p=130:14:2551972738979005909::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,466228.1,1,0,1,helvetica

    You actually don't need Linux driver to connect to Oracle I have used Oracle in Solaris, HP and IBM Iseries and all that is needed is the Oracle client for the Windows operating system and your TNSNames.Ora file.

    Kind regards,
    Gift Peddie

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply