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