Still doesn't work...

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