Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting ODBC
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00557845
Message ID:
00561934
Vues:
41
>Too much cuttin'-and-pastin':
>#INCLUDE ODBC.H
>lcDriverName = ODBC_MS_ORACLE
>lcSettings   = "DSN=Connect1_or_better_description" + chr(0);
>             + "Description=Your_Description_Here" + chr(0);
>             + "Server=host_name_in_tnsnames.ora_file"+chr(0);
>             + "UID=myuserid"
>llModifyDSN  = .f.  && optional. default is false
>oODBC = newobject('odbc', 'odbc.fxp')
>llSuccess = oODBC.CreateUserDSN(lcDriverName, lcSettings, <b>llModifyDSN</b>)
>oODBC.Release
>return llSuccess
I get .f. for llSuccess. DO I have all things in place? So I need odbc.prg with my parameters in place and the code above also with my parameters in place. How come the code above does not ask for a PWD? Again is the concept to create a user dsn then be able to SQLExec() for some oracle server data?
-possibly hopelessly lost
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform