Thank you.
>Sorry, I don't have access to an Oracle server right now but the Fox Wiki has an example that uses the full domain name for the Data Source...
>ex. "Data Source=data.mine.com"
>
>
http://fox.wikis.com/wc.dll?Wiki~UsingADO~VFP>
>
>
>- Brian
>
>
>
>>Still doesn't work...
>>
>>>
>>>Hi Jayesh,
>>>
>>>Try adding .1 at the end of the Provider
>>>
>>>?loConnect.Open("Provider=MSDAORA
.1;Data Source=MySource;User Id=MyUserId;Password=MyPassword;")
>>>
>>>If I create a udl file, it has a .1 at the end.
>>>
>>>
>>>HTH,
>>>
>>>- Brian
>>>
Does anyone know how to connect to Oracle 8.x using MS OLE DB provider? The following code doesn't work. It doesn't give any error but returns NULL
>>>>
>>>>loConnect = createobject("adodb.connection")
>>>>?loConnect.Open("Provider=MSDAORA;Data Source=MySource;User Id=MyUserId;Password=MyPassword;")
>>>>
>>>>I can connect via SQL*PLUS and Oracle ODBC Provider.
>>>
- Jayesh