Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't connect to Oracle Dbase with SQL Server 2005 Express

Re: Can't connect to Oracle Dbase with SQL Server 2005 Express

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 19 Dec 2005 08:47:52 -0800
Message-ID: <1135010858.681247@jetspin.drizzle.com>


Crazy Cat wrote:
> Hi Mark,
>
> I figured mabye my problem could be solved by upgrading the version of
> Oracle so I installed Oracle 10.1 on Friday and had success with the
> Microsoft Oracle OLEDB provider -- not so with the Oracle provider, but
> rather than wasting a bunch of time figuring out why I couldn't connect
> with that I figured the MS Oracle DB provider would fill my needs.
> However this morning I attempted to once again connect via SQL Server
> Express figuring and had gotten over the hurdle and I got a new error
> -- OLE DB provider "MSDAORA" for linked server "MSORACLE" returned
> message "Oracle error occurred, but error message could not be
> retrieved from Oracle.". And again I can connect to this database fine
> using PL/SQL Developer. So once again I'm back to square one and
> totally perplexed. Any idea how
> to retrieve the Oracle messages?
>
> As to why I'm using SQL Server Express -- I am doing an MS Excel
> automation project, so I'm not quite sure that Oracle is an option on
> the client side. Also the backend is not on my machine -- I actually
> have no idea where it is, except that I know it's some huge (6
> Terabyte) database server somewhere.
>
> By "Local to remote mapping" I'm referring to the selection on SQL
> Server Express' Security Property Page (right click on Properties for
> the linked server, then click on the Security selection in left pane of
> the dialog box that appears). It appears to allow you to enter a user
> and password combination that will be used to attach to the linked
> server.
>
> Thanks again

If you are in the United States you might want to take a good look at the requirements of Sarbanes Oxley and your probable violation by using MS Excel.

If you have something to do with Oracle data you might want to just leave it in the Oracle database and create your reports directly from that repository.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Dec 19 2005 - 10:47:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US