Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2007-08-02 : 14:56:51
|
| Forgive me if the questions does not make sense.My Environments:-1. Sql Server 2005 Ent. Ed SP2 / Windows 2003 Server2. Sybase ASE 12.5 / Solaris3. Oracle 10g 64Bit / I think its Windows 2003Question #11. Is it possible to create Sybase and Oracle as Linked Servers in Sql Server 2005 (considering the env above)This may be very stupid question2. Can I create a view in the Sql Server with underlying tables from these linked servers?3. If #2, is possible, If I update a record in view will it be able to update the underlying table.ThanksKarunakaran |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 22:38:38
|
| 1. possible, may need install proper clients on sql server.2. yes you can.3. not sure if it's possible, but you can update table directly via linked server. |
 |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2007-08-02 : 23:28:37
|
quote:
Originally posted by rmiao
1. possible, may need install proper clients on sql server.2. yes you can.3. not sure if it's possible, but you can update table directly via linked server.
Thanks rmiao.Let me see how it goes.ThanksKarunakaran |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2007-08-03 : 12:39:46
|
| Has any body successfully configured Sybase as linked server in SQL Serer 2005 with out using ODBC or ids files?I like to configure the linked server using connection string rather than ids or odbc.Any pointers will be helpful.ThanksKarunakaran |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2007-08-03 : 19:13:11
|
Well, my DBA shot down the idea of using Linked Server  ThanksKarunakaran |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-06-11 : 16:03:26
|
| karuna,why? |
|
|
|
|
|
|
Linked Server - Sql Server - Oracle - Sybase