the string connection is very simple:
=SQLSetProp(0,"Displogin",3)
lnhandle = SQLSTRINGCONNECT('dsn=Yourserver;uid=YouruserID;pwd=yourPass')
=sqlsetprop(lnhandle,"displogin",3)
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.
>>>>