You need to look at the code where the DSN 'Oracle Test' Created - .T. was created. Modify this code to create your DSN. You can remove the DSN off your computer and test recreating it with my class and that code. >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', llModifyDSN) >llSuccess = oODBC.CreateUserDSN(lcDriverName, lcSettings) >oODBC.Release
Mark, a little bit confused here. I modified the odbc.prg to fit my specs as you suggested as above on the 1st line of your response.. AM I to rerun the odbcdemo at this point? What is the code above that you supplied? DO I run it in a seperate prg?
"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."