Re: oleDB and Oracle 9

On Fri, 02 Aug 2002 19:40:03 +0200, Oliver Otto <ootto_at_genese.de> wrote:

>Hallo,
>
>how can I access via Microsoft's oleDB to an Oracle Server. If I install
>the Oracle oleDB drivers everything seems to work fine without any
>timestamps. The application crash directly while reading any data.
>
>Now I want to install the oleDB from Microsoft for Oracle but can not
>connect. Any hints to this ..? The
>
>May connect string looks like this:
>
>Call SqlCreateSession( hSession, "Provider='MSDAORA';User
>ID='sysadm';Password='sysadm';Data Source='pa01hbor';" )
>
>The database is accessable in fact of the point that the following
>command works (ok this is the Oracle oleDB driver, but it shows that it
>is not the connection.):
>
>Call SqlCreateSession( hSession, 'Provider=OraOLEDB.Oracle;User
>ID=sysadm;Password=sysadm;Data Source=PA01HBOR;' )
>
>
>The error message is: "Oracle error occurred, but error message could
>not be retrieved from Oracle." It looks like if the connect string is
>still wrong but it looks like the examples from the Microsoft homepage
>..?!?
>
>Thanx for any hint
>
>Oliver

Doing your homework for you I found the following link http://otn.oracle.com/docs/tech/windows/ole_db/doc/html/using.htm#1004840

with the following remark

When connecting to a remote database, Data Source must be set to the appropriate Net8 connect string which is the alias in the tnsnames.ora file. For more information on Net8, refer to Net8 Administrator's Guide.

You could have better done some research yourself instead of posting the same RTFM question two times on one day.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Aug 02 2002 - 13:21:09 CDT