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