Read-only connection using i Access ODBC

Connection string

This IBM i Access ODBC driver connection string can be used for connections to AS/400.

Enbales SELECT statements only. No UPDATE etc.

Driver={IBM i Access ODBC Driver};System=mySystem;UID=myUser;PWD=myPassword;
CONNTYPE=2;

Default is CONNTYPE=0 meaning all SQL statements allowed. CONNTYPE=1 means SELECT and CALL statements is allowed.