unix odbc sqlserver link
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: