I wanted to use OLE DB provider not ODBC...It works fine with ODBC...

>the string connection is very simple:
>

>=SQLSetProp(0,"Displogin",3)
>lnhandle = SQLSTRINGCONNECT('dsn=Yourserver;uid=YouruserID;pwd=yourPass')
>=sqlsetprop(lnhandle,"displogin",3) && no loging
>

>but you have to make sure you have the right drivers, specially for ORACLE 8.
>If not is not gonna work.
>If you had ORACLE 7.3 and then try to connect to a database from ORACLE 8 you out of luck.
>
>>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.
>>>>>