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 |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2009-03-12 : 14:16:27
|
| Hi All,I’m facing 2 problems,this is very urgent.I’ve created link server in Sql Server Management Studio using Microsoft OLE DB Provider for Oracle. I can see the Oracle tables, version 10g in it. My question is I’m unable to see the fields in the Oracle tables and also select any values from them. How do I write DML, DDL queries for linked tables?The other question is how to create reports in Sql Server reporting services 2005 using Oracle (10g) linked tables. Could you please let me know if there is any documentation available? I appreciate all the help provided.Thank you, |
|
|
|
|
|
Select query using linked server