(More or less a question to confirm my test results...) I want to connect to a strongly encrypted database on a not-running, local database engine. I want to use a ODBC DSN and want to get asked for the encryption key. This can be done by means of the -ep server option. Is the only way to do so by specifying the START connection parameter, i.e. something like the following (with need to specify the server command line)?
I would favour the usage of DBS=, but this does not seem to work (with error "Invalid option for local database"). I guess it does not work as -ep is a server option, not a database option, and DBS is only valid for database options. (Note: I refer to command line options, not the ones available by SET OPTION.) Am I right, or is there a better way? (For simplicity, I would like to omit the server command line.) EDIT to put it more generally: Is the following correct w.r.t. connection parameters?
|