08-14-2018 07:37 AM
High Priority
Good day SnapLogic Community
I am trying to connect to DB2 on an iSeries(AS400) using JDBC but I am getting the following error,
Failed to validate account: Failed to retrieve a database connection. Cause: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>. (Reason: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS <IDENTIFIER>.; Resolution: Please address the reported issue.)
It worked before but is not working now even though i made no changes to the pipeline. I am using the class “com.ibm.as400.access.AS400JDBCDriver” in the jt400-6.4.jar file which I am referencing.
Thank you very much in advance for your help!
Regards
Andre
08-14-2018 09:38 AM
Can you share your account configuration screen?
08-14-2018 09:57 AM
blank testing
08-14-2018 10:30 AM
Looks like you have not populated a username?
08-14-2018 11:34 AM
I left out the user name when I posted it here.