urgent: linked server to Oracle database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JJ Wang (anonymous_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Mon, 21 Jun 2004 18:09:33 -0700

hi,

We have an sql server 2000 server. On this sql server we
have linked servers connected to Oracle servers (one is on
8i and the other is on 9i).

We discovered that
1.
linked servers using 'Oracle provider for OLE DB' won't
allow select queries to pull data from Oracle server,

2.
the linked servers using 'Microsoft OLE DB provider for
Oracle' or 'Microsoft OLE DB Provider for ODBC Driver'
won't allow batch insert (insert commands) into Oracle db
tables.

Why is that? We really wish taht we can set up just one
linked servers to do both 'select' and 'insert' with
Oracle server from our sql server.

btw, what's the difference between the two Microsoft
drivers listed above?

any help is highly appreciated.

JJ

Relevant Pages

  • Re: Capturing Error Message Text
    ... Unfortunately it seems that SQL Server is unable to ... disruptions of connectivitly to the many linked servers that our databases ... >> I have looked everywhere on how to actually capture error message text, ...
    (microsoft.public.sqlserver.programming)
  • Re: How to get an unix programmer started on web programming?
    ... Don't allow access to your Oracle server through the web, especially if you have confidential data on it that's not needed by the web. ... Rather, replicate only the data necessary to run your website to another database accessible by the web server. ... A well written system will not allow a user to hack your system and access arbitrary bits of data in a database nor destroy a database. ...
    (comp.lang.php)
  • Re: How to get an unix programmer started on web programming?
    ... >> Don't allow access to your Oracle server through the web, ... >> the changes back to your main database. ... If the hacker hacks he'll hack your subset database and ...
    (comp.lang.php)
  • Re: Linked servers and distributed transactions question
    ... > Loopback linked servers cannot be used in a distributed transaction. ... > Microsoft SQL Server MVP ... > I support the Professional Association for SQL Server ... One database sitting on each server. ...
    (microsoft.public.sqlserver.server)
  • Re: How to get an unix programmer started on web programming?
    ... Don't allow access to your Oracle server through the web, especially if you have confidential data on it that's not needed by the web. ... Rather, replicate only the data necessary to run your website to another database accessible by the web server. ... If the hacker hacks he'll hack your subset database and such a hack will probably be as painful. ...
    (comp.lang.php)