lavals[1,1] “Driver” lavals[1,2] “C:\WINDOWS\System32\odbcjt32.dll” lavals[2,1] “DefaultDir” lavals[2,2] “C:\PROJECTS\CSST\REPORTS\PIR2003” lavals[3,1] “Description” lavals[3,2] “connection to Xtria PIR report software table” lavals[4,1] “DriverId” lavals[4,2] 533 lavals[5,1] “FIL” lavals[5,2] “dBase 5.0” lavals[6,1] “Safe Transactions” lavals[6,2] 0 lavals[7,1] “UID” lavals[7,2] “”My code to recreate the DSN looks like this:
lcConnectionString = "DBQ=" + lcPath + CHR(0) + ; "DefaultDir=" + JUSTPATH(lcPath) + CHR(0) + ; "Description=Report Table DSN" + CHR(0) + ; "Safe Transactions=0" + CHR(0) + ; "UID=" + CHR(0) loODBC.CreateUserDSN(ODBC_MS_DBASE,lcConnectionString)…where loODBC is the instance of Mark’s class, ODBC_MS_DBASE is the driver name, and lcPath is the full path name of my dBase target table. I’ve tried just about every combination of settings in the connection string that I can think of, but still no success creating the DSN on the fly. Can anyone point out where I’m going wrong?