A connection to the database will not work properly in Workbench if it contains a semicolon. This is because ';' is the delimiter the ODBC or OLE DB driver uses to separate the entities of the credential string. If the username or password contains a semicolon, the driver string will be corrupted. See below for an example connection string created by the ODBC driver.
Driver={NetezzaSQL};server=exampleserver;UserName=exampleuser;Password=examplePassword;Database=exampledatabase;LoginTimeout=120
Any extra semicolons will cause the above string to not work properly.
0 Comments