Database Utilities (MOSC)

MOSC Banner

unix odbc sqlserver link

edited Dec 30, 2016 4:01AM in Database Utilities (MOSC) 1 commentAnswered

Hi,

i created a db link using unixodbc and Microsoft ODBC Driver 11 for SQL Server as described in this tutorial:

Oracle 11g Database Link to Microsoft SQL Server | MinhTech.com

the db link seems to work:

SQL> Select * from  dbo.log1@sqltest_link;

    ID Track                                                                                                    whatever

---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------

     1 track1                                                                                                    whatever1

     2 track2                                                                                                    whatever2

     3 track3                                                                                                    whatever3

     4 track4                                                                                                    whatever4

     5 track5                                                                                                    whatever5

     6 track6                                                                                                    whatever6

     7 track7                                                                                                    whatever7

     8 track8                                                                                                    whatever8

     9 track9                                                                                                    whatever9

    10 track10                                                                                                    whatever10

10 rows selected.

SQL> Select ID from  dbo.log1@sqltest_link;

    ID

----------

     1

     2

     3

     4

     5

     6

     7

     8

     9

    10

10 rows selected.

But if I try to select a column which is not created with uppercase, I'm getting this error:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center