Connection to open target db fails when running db setup with below error:
Error: [SP-SYS01004] No DSN name in the connection string.
<CAUSE>: The connection string must include a Data Source Name (DSN)
<ADVICE>: Try again using a connection string that includes the DSN for the database.
Resolution:
SOLUTION:
Provide a valid connection string, see connection string guidelines below:
On open target:
1) set a connection string
sp_ctrl> connection r.mydb set connect_string="driver=/database/ODBC/lib/databasedriver.so;server=server1;port=1234;uid=myuser;pwd=mypassword"
2) Try again the setup program
