June 22, 2009 at 2:34 pm
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
----------------------------------------------------------------------------
June 22, 2009 at 2:48 pm
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
----------------------------------------------------------------------------
June 22, 2009 at 4:26 pm
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