John Barry
Rank: #8755
6Views
2Comments
iSeries Database connection string error
Question
Service
Application Type
Service
Platform Version
11.10.0.25600

I'm tryin to set the connection string, to our iSeries, in the Advanced Configuration panel, in Administration/Database Connections and I'm receiving the below error:

Connection String test failed: The ConnectionString property is invalid.  

The connection string that I'm using is:
UserId=<hidden>;Password=<hidden>;Server=xx.xx.xxx.xx:8471; database=PDB2;libraries=PDLIB1,PDLIB2,PDLIB3,PDLIB4,;

where 8471 is the port for the database listener 

0
0
on 2020-12-17
Copy link to comment
0
0
on 2020-12-18
Copy link to comment
Daniël Kuhlmann
mvp_badge
MVP
Rank: #17

Hi John,

I am not sure, but you are not following exact naming conventions, maybe it helps if you do

  • Try UID of User Id (with space) instead of UserId
  • Database instead of database
  • I don't know about the Libraries property, did you try without?

Regards,

Daniel

0
0
on 2020-12-18
Copy link to comment