Post your modified code of what I given you below. I never recommend embedding a password in the DSN. I just create the DSN and use it to open a dummy remote view after the user Provides their UserID and Password in a VFP form. You have to use the Host name you created in the TNSNAMES.ORA file for the Server parameter.

>>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