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 |
|
besom
Starting Member
11 Posts |
 Posted - 2008-01-12 : 06:50:43
|
| 1. Is the possible to create synonym in SQL2005 with Oracle Table or On the contrary 2. Crate DBLink between SQL2005 and Oracle |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-12 : 12:23:34
|
| 1. create linked server to oracle and try.2. same with linked server. |
 |
|
|
rjgamer
Starting Member
8 Posts |
Posted - 2008-01-14 : 10:59:04
|
| I have created a linked server to Oracle 10g before from SQL 2005. I was then able to join SQL and Oracle tables in the same query, and it seemed to work okay. |
|
|
|
|
|
|
SQL2005 and Oracle 10g