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

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 Received on Mon Dec 19 2005 - 09:50:11 CST