[SP-SYS01004] No DSN name in the connection string (4222586)

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