Re: Oracle 8.0.5 and ADO 2.0 Question

The keywords "Server" and "Database" have no effect in the connection. For MSDAORA, the keyword "Data Source" is the only one that matters.

Regards,

Carlos J. Quintero Vivar
Madrid (Spain)
cvivar_at_cat.es

Josy escribió en mensaje ...
>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 Thu May 20 1999 - 02:17:05 CDT