var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have created a linked server to oracle, which works fine.
But when I try and create a view joining the SQL table with the linked Oracle table, it only returns the primary key field in the Oracle table and nothing else.
Anyone know why?
N.B. I'm using SQL Server 2005 btw.
<- Hides behind a rock.
At least at first, I'd bet on Oracle permissions for the linked server login.
I use the same username and password when running queries in Access linked to the same Oracle server. And these run fine.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors