I'm not sure what you seek is possible. The DNS >>> IS <<< the designated means of connecting to the database, and the paramemters for the connections are specified in that DNS.

If you want to change connection parameters at runtime I suggest you 1) create a new DNS synamically OR have a separate DNS available (i.e. already created but not in use), 2) close the existing connections, and 3) reconnect with the new DNS.


If you wish, you can connect to the database without a DNS at runtime. Here's an example of such a connection that you would use with SQLCA (or whatever transaction object you choode):
     DBPARM = ConnectString='DSN=PostgreSQL35W;UID=cabdevusr;PWD=cabdevusr',DelimitIdentifier='No',LoginTimeOut=99",DisableBind=1

Hi Pawel,

You can try this:

1. Tick the Ignore Timeout checkbox at PostgreSQL ODBC的Options - > Datasource (Page1) -> Ignore Timeout (Attachment #1).
2. Then set the Timeout value at PB Database Profile Setup->Network->Login Timeout (Attachment #2).

When I set LoginTimeOut=1 here, it will prompt timeout expired and the message is gone when I set LoginTimeOut=10, which means LoginTimeOut is effective when it connects.

SQLCA.DBParm = "ConnectString='DSN=PostgreSQL35W;UID=postgres;PWD=<******>',LoginTimeOut=99"

Best Regards,

Peter

SQLCA.DBMS = "ODBC"
SQLCA.Database = ddlb_database.Text
SQLCA.UserID = sle_userid.Text
SQLCA.DBPass = Trim( sle_password.Text )
SQLCA.DBParm = "DisableBind=1,AutoCommit=0," + "ConnectString='DSN=" + SQLCA.Database + ";UID=" + SQLCA.UserID + ";PWD=" + SQLCA.DBPass + "',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT;LoginTimeOut=0'"