Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5 and ADO 2.0 Question
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/assetviewintranet: http://ovweb.bbn.hp.com/itservicemanager