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 |
|
Riya
Starting Member
6 Posts |
 Posted - 2009-03-17 : 05:29:13
|
| can i access loacal database 10g through sql serever 2005?lacal database is oracle database and i want to access it through sql server 2005.Please telll me the complete method.thanks in advance |
|
|
pootle_flump
1064 Posts |
Posted - 2009-03-17 : 05:31:29
|
| Yes |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-03-17 : 05:32:04
|
| Yes you can using either of the following options:1. Add 10g as linked server2. OPENROWSET()3. OPENDATASOURCE()Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-17 : 07:02:45
|
| http://msdn.microsoft.com/en-us/library/aa936675(SQL.80).aspxhttp://msdn.microsoft.com/en-us/library/ms190312.aspx |
|
|
|
|
|
|
sql server features