Link Sql Srv with Orcale in deffrent Operating system

how to link my sql server to orcale db in defferent OS

assume that master DB in OS Unix and orcale server

I needed to link my sql server in other computer to the unix computer
to access the db in oracle.

I try to use ODBC but have a problem in must install oracle client
please help meIf you are using linked servers the OS isn't important. Check out the Books On Line article entittled "linked servers, configuring". It is well written. This should help you setup a link between your SQL server and Oracle.

Link Server settings

Hello:
I am trying to create linked server ( another SQL Server) to my SQL Server,
using Enterprise Manager, but new alias pointed me only to master database.
How can I change settings of the link server to get access to pubs database?
Thanks,
GBYou could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||You could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||What you see in Enterprise Manager is simply the default database for the
account that you are using to authenticate to the linked server. Changed th
e
default database for that user, and refresh and you will see another
databases tables.
You will still be able to access all databases to which that user has access
.
kevin
"GB" wrote:

> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL Server
,
> using Enterprise Manager, but new alias pointed me only to master database
.
> How can I change settings of the link server to get access to pubs databas
e?
> Thanks,
> GB
>
>