SQL Server ODBC driver for Linux

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Working with Oracle » SQL Server ODBC driver for Linux

SQL Server ODBC driver for Linux

Rate Topic

Display Mode

Topic Options

Author

Message

SQLDCH

Posted Monday, June 22, 2009 2:34 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 7:41 PM
Points: 891, Visits: 2,263

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.

----------------------------------------------------------------------------
My LinkedIn profile - LinkedIn
Sacramento SQL Server users group - http://sac.sqlpass.org
My blog - http://www.expressnetsolutions.com/sqldch
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.

Post #739746

SQLDCH

Posted Monday, June 22, 2009 2:48 PM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 7:41 PM
Points: 891, Visits: 2,263

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

----------------------------------------------------------------------------
My LinkedIn profile - LinkedIn
Sacramento SQL Server users group - http://sac.sqlpass.org
My blog - http://www.expressnetsolutions.com/sqldch
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------

Yeah, well...The Dude abides.

Post #739756

Gift Peddie

Posted Monday, June 22, 2009 4:26 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

dh (6/22/2009)

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

Post #739804

« Prev Topic | Next Topic »

Permissions