Thread: Incorrect behavior connecting Oracle vs SQL Server

Hi to all, i have tried to link an oracle db to sql server db (for example northwind). The link work fine, but if from sql plus i execute: sql>describe employees@myfisrtdsn; where employees is the table in sql server db and myfirstdsn is the link-name, only these colums is displayed: name null? type ----------- -------- ------------ employeeid not null number(10) birthdate date hiredate date photo long raw reportsto number(10) the others are ignored. I don't understand this behavior. Can someone help me ? in the attachment are the steps creating a link. thank you for hope and best regards gaetano