August 31, 2009 at 4:57 am
I need to configure linked server between SQL server and Oracle database.
I don't have Oracle client installed in SQL server.
Can this be established in the following was?
Step1: Configure linked server between SQL server(where Oracle client present) and Oracle
Step2: Configure linked server between SQL server and SQL server to get the data from Oracle db.
Please let me know can this be done.
If not kindly provide some suggestion to handle this task.
Thanks,
Keerthi
August 31, 2009 at 6:10 am
Hi
NOTE:if u can configure the oracle
please check the article if want to configure the linked server to oracle
http://support.microsoft.com/kb/280106
Regards
sat
August 31, 2009 at 6:25 am
I need to configure linked server between SQL server and Oracle database.
I don't have Oracle client installed in SQL server.
Can this be established in the following was?
Step1: Configure linked server between SQL server(where Oracle client present) and Oracle
Yes, You can add linked server between SQL server and
Oracle. You need to have oracle client installed for the same.
Step2: Configure linked server between SQL server and SQL server to get the data from Oracle db.
I dint get this question. What do you mean by this.? Pls clarify.
August 31, 2009 at 10:11 pm
Actually i need to configure linked server in SQL server(SERVER1) which doesn't have oracle client. Instead of installing the oracle client in the SQL server(SERVER1), i had another SQL server (SERVER2) which had Oracle client. Now can i create a linked server in SERVER2 to access data from Oracle db and use another linked server between SERVER2 and SERVER1 to get get the Oracle db information?
Data flow will be something like this.
Oracle ------> SERVER2 --------> SERVER1
Thanks,
Keerthi
August 31, 2009 at 10:49 pm
Yeah, I got your question now. I have never tried that way. Don't think you can directly access oracle database from SERVER1 this way.
Probably you can create temporary tables/Views in SERVER2 and access from SERVER1. So it will linked server between Oracle-SERVER2 and SERVER2-SERVER1
Someother experts might help you as well.
August 31, 2009 at 11:42 pm
Try this,
Follow the Link Might be helpful : http://www.mssqltips.com/tip.asp?tip=1433
EXEC sp_addlinkedserver
@server = 'Server Name'
, @srvproduct = ''
, @provider= 'SQLOLEDB'
, @datasrc= 'IP Address'
GO
sp_addlinkedsrvlogin @rmtsrvname = 'Server Name'
,@useself = 'FALSE'
,@locallogin = 'LOGIN'
,@rmtuser = 'RemoteLogin'
,@rmtpassword = 'RemoteLogin Password'
GO
Thanks.
___________
Win.
Cheers,
- Win.
" Have a great day "
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply