Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Programmatically create an ODBC, system/user DNS?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00289382
Message ID:
00305635
Vues:
19
>Mark do you what the available parameters are? Parameters Such as userid, password, under client configuration (network libraries), etc.

Best advice I can give is for you to create a DSN for each source you need to connect to using the ODBC Administrator in Control Panel. Then use regedit and look in HKEY_CURRENT_USER\Software\ODBC\ODBC.INI to get a list of all the string values you can pass. YOu can include any of those values in the lcSettings parameter I gave in my example in Article #223.
lcSettings = "DSN=Locator"+chr(0);
             +"Description=Region 6 Locator"+chr(0);
             +"Server=OraServer"+chr(0);
             +"UID=optional"+chr(0);
             +"PWD=optional"+chr(0);
             +"string=value"
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform