Re: Oracle 8.0.5 and ADO 2.0 Question

From: Josy <service_at_huefner.com.au>
Date: Thu, 20 May 1999 11:12:02 +0930
Message-ID: <OIl$PFmo#GA.263@cppssbbsa03>

Beth,

I have been using ADO 2.0 and Oracle 8.0.5 successfully. Below is the connection string we used.

Set db = New ADODB.Connection

  db.ConnectionTimeout = 180
  db.CursorLocation = adUseClient
  db.Open "Provider=msdaora;Server=ENDOR;Data Source=JABBA; database =

JABBA; User Id= TIM;Password=TIM;"

  Set adoPrimaryRS = New Recordset
  adoPrimaryRS.Open "select Firstname, Surname from JABBA.Customer", db, adOpenStatic, adLockOptimistic

So it can be done. Can you create a DSN through ODBC 32 (in control panel) or access your Oracle database through MS Query?

Just a note... DON'T upgrade to MDAC 2.1 as there are problems with Oracle connection and ADO.
Josy.

Beth Massi wrote in message <7fqel5$8rt_at_sjx-ixn9.ix.netcom.com>...
>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
>
>
>
Received on Wed May 19 1999 - 20:42:02 CDT