Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to Oracle
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00689674
Message ID:
00689764
Vues:
27
Hi Jayesh,

I'm home running my Oracle db (8.1.7) and I can connect fine using:
loConnect = createobject("adodb.connection")
loConnect.Open("Provider=MSDAORA.1;User ID=scott;Password=tiger;Data Source=MyOracleDB;Persist Security Info=False")
Which version of MDAC are you running? I have 2.7 installed.


- Brian



>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


VFP6 SP5, VFP8 SP1, VFP 9 SP 1 and Win XP SP 3 (unless otherwise specified)


www.wulfsden.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform