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.
>>