var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is there a way to define the Oracle server and schema as a property in a linked server? I need to link to server 'g1' and a schema 'trl.' I can define the server or the schema but not both. I tried this:
@server = 'test',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'g1',
@location = '',
@provstr = '',
@catalog = 'trl'
The sp executed but the linked server didn't work. I imagine obviously because the "schema" isn't a catalog.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors