Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server ODBC driver for Linux Expand / Collapse
Author
Message
Posted Monday, June 22, 2009 2:34 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 1,266, Visits: 2,730
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.
Post #739746
Posted Monday, June 22, 2009 2:48 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 1,266, Visits: 2,730
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.
Post #739756
Posted Monday, June 22, 2009 4:26 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 9:41 AM
Points: 3,433, Visits: 14,421
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
Post #739804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse