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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5 and ADO 2.0 Question

Re: Oracle 8.0.5 and ADO 2.0 Question

From: Ruud de Koter <ruud_dekoter_at_hp.com>
Date: Thu, 29 Apr 1999 09:43:19 +0200
Message-ID: <37280D97.49696DB3@hp.com>


Hi Beth,

Don't know whether there are a lot of people using ADO and Oracle8, but we do at the site where I work.

As far as I have heard and experienced, ADO is very sensitive to changes in the environment. Sometimes (unfortunately this is not a invariable rule), after installing
a new Oracle version, there is no alternative but installing the whole MS stuff again (we often use parts of option pack for NT, which also includes MTS).

Basically, we have the same setup you describe: Oracle 8.0.5 on a HP-UX server, approached from a NT client, running Oracle 8.0.5 client software and ADO 2.0. Let me assure you, this is a working setup.

As for the MSDAORA.dll, we are using version 02.00.3002.15, 183.056 bytes, of the 24th of June, 1998. On my system it is located in the directory "C:\Program Files\Common Files\System\ole db". What we pass on as the connection string is:
Provider=MSDAORA.1;Password=<password>;User ID=<user name>; Data Source=<arbitrary name>
 (I don't know what the '1' does in the provider part, but is seems to help).

Hope this helps,

Regards,

Ruud de Koter

Beth Massi wrote:

> Hi,
> Nobody posted any replies to the last post I made, so I thought I'd ask one
> more time. Guess not many people use ADO to access Oracle 8, huh?...
>
> I have a question regarding Oracle Version 8.0.5 and ADO 2.0.
> I am new to ADO and was under the impression that I was supposed to use the
> MSDAORA Provider when connecting to Oracle via ADO, however, when I try to
> open the connection it gives me an error message "Driver not capable". So I
> tried MSDASQL provider and it will let me connect, update, addnew recordsets
> and everything, which is great, but it won't let me create disconnected
> recordsets now. I get the error message "Operation is not allowed if the
> object is closed" if I try to do anything to my Client side recordset after
> disconnecting it (closing the connection). I am also concerned that the
> MSDASQL Provider will give me more trouble as I go on developing. Is there
> a version compatibility issue with MSDAORA Provider? Do I need to download a
> patch or something? or do I need to work with Oracle 7.3?
>
> Thanks in Advance!
> Beth


Ruud de Koter                              HP OpenView Software Business Unit
Senior Software Engineer              IT Service Management Operation
Telephone: +31 (20) 514 15 89    Van Diemenstraat 200
Telefax     : +31 (2) 514 15 90      PO Box 831
Telnet       : 547 - 1589                  1000 AV  Amsterdam, the Netherlands
Email         : ruud_dekoter_at_hp.com

internet: http://www.openview.hp.com/itsm

             http://www.openview.hp.com/assetview

intranet: http://ovweb.bbn.hp.com/itservicemanager
Received on Thu Apr 29 1999 - 02:43:19 CDT

Original text of this message

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