[IBM][iSeries Access ODBC Driver]Connection login timed out.

[s***@yahoo.com]

I have split the code. The error is happend at DB2cnn.Open()

BTW, will creating/destroying a lot of connection object through IBM ODBC causing any issue?

[d***@ermco-eci.com]

Opening and closing connections should not be an issue and usually the recommended method.

You might try setting the ConnectionTimeout property in your connection string to a value higher then 15 seconds which is the default.

"DataSource=myiSeries;ConnectionTimeout=30"

[d***@ermco-eci.com]

If you are doing multiple updates you may want to rewrite your code slightly so that the connection remains open during those multiple updates and then close it. Just don't hold it open any longer then necessary.