Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting ODBC
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00557845
Message ID:
00561934
Views:
40
>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."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform