Re: oleDB and Oracle 9

Hallo,

I do not know why I post the question two times. Maybe it was a long night before trying this stupid oleDB driver. After a complete setup of the workstation everything works fine. Don't know what happen before.

The only problem now is to read and write timestamps. The oleDB driver from Microsoft has the same problem as the Oracle driver. Both are not able to do this. I found a link at otn.oracle.com that this is not possible for 9.0 driver but no remark for 9.2.x. Within our tests this also do not work and Oracle German has no answer to this either. Will there be a solution in the future ..?!

Greetings

Oliver

Sybrand Bakker wrote:

> 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 Mon Aug 05 2002 - 07:46:19 CDT