OK, I am having trouble understanding the Settings (DSN/Driver) field on the Import screen.
I have a Import Preset with everything else input.
I have a defined DSN for MS Sql Server called DclEmail.dsn
If I try to run it with anything in the Settings field, it craps out.
eg DclEMail returns "The specified DSN conatins an architecture mismatch between the Driver and Application"
If I leave the field blank, it prompts me to choose the DSN ( I choose the same file) , asks me if I want to save the changed settings and does the import. But does not save the value in the Preset.
any ideas?
I have a Import Preset with everything else input.
I have a defined DSN for MS Sql Server called DclEmail.dsn
If I try to run it with anything in the Settings field, it craps out.
eg DclEMail returns "The specified DSN conatins an architecture mismatch between the Driver and Application"
If I leave the field blank, it prompts me to choose the DSN ( I choose the same file) , asks me if I want to save the changed settings and does the import. But does not save the value in the Preset.
any ideas?