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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-02 : 09:02:51
|
Jay writes "I have just installed Sql Server 2000, the production database is an Oracle 8.1 database. Is it possible to link to all the Oracle tables from Sql Server. Basically I'm looking for the same functionality that Access offers where you can make ODBC links to tables in other databases (I would prefer to use OLE DB if at all possible).
My reasons for this are that I need to try out Sql Servers XML generation capablities against my Oracle database. I am evaluating between XML generated using Oracle Xsql Servlet and Sql Server.
I have created a linked server to the Oracle database which means I can write my queries against the data, but I would like to presented with the full view.
Thanks in advance for any assistance you can give me.
I am running Windows 2000 Service Pack 1 and Sql Server 2000" |
|
|
|
|
|
Linking Sql Server to Oracle Tables