Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved ODBC connection timeout

  1. How-to
0
Votes
Undo
  1. Paweł Kasperek
    Paweł Kasperek
  2. PowerBuilder
  3. Wednesday, 22 February 2023 10:45 AM UTC

Hi,

 

I have got a problem with the connection to the remote database server. I used Postgres database via ODBC. How can I set connection timeout in PB transaction or connection configuration? I would change the connection timeout parameter from the application, not in ODBC DNS.

Regards,

Pawel

 

Webbrowser control is not loading PDF file when ap...
Failed using Mscomm32 with 64 bits powerbuilder ap...
Accepted Answer
Paweł Kasperek
Paweł Kasperek Accepted Answer Pending Moderation
  1. Thursday, 29 February 2024 16:07 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi,

 

Currently, I don't resolve my problem with connection timeout when I use ODBC PostgreSQL driver. But I migrated to ADO.NET Postgresql provider and the problem is resolved.

Comment
There are no comments made yet.
Responses (3)
Peter Pang @Appeon
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 February 2023 05:29 AM UTC
  2. PowerBuilder
  3. # 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

Attachments (2)
PostgreSQLodbc.png PostgreSQLodbc.png
DatabaseProfileSetup.png DatabaseProfileSetup.png
Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 22 February 2023 23:35 PM UTC
  2. PowerBuilder
  3. # 2

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

 

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.