PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 27 → Error 72810 and 22 No Connection to Server
Error 72810 and 22 No Connection to Server
Débuté par Hengky L, 23 oct. 2022 14:18 - Aucune réponse
Posté le 23 octobre 2022 - 14:18
Hi,

I really frustrated with this problem. I experience connection problem with Windev very often when connecting to postgresql cloud database. Here is the error message :

72810 - The native PostgreSQL access indicated to HFSQL that an error occurred but did not return the error to HFSQL.

After this error then no connection to server error appear :

22 - What happened?
The following error was returned by the <xxx.xxx.xxx.x> database:
Error number = <0>.
Error message:
no connection to the server

Error code: 22
Level: fatal error

Dump of the error of 'wd240postgresql.DLL' module (24.0.15.0).
Identifier of detailed information (.err): 22
Debugging information:
IEWDPSQL=100.19
Module=<WDPSQL>
Version=<24.0.15.0>
Client layer: internal
Provider: WinDevPostgreSQL

I connect to the postgresql database using this code :

gctMypostgresql is Connection
gctMypostgresql..Provider = hNativeAccessPostgreSQL
gctMypostgresql..User = myuser
gctMypostgresql..Password = mypassword
gctMypostgresql..Server = myserverip
gctMypostgresql..Database = mydatabase
gctMypostgresql..Access = hOReadWrite
gctMypostgresql..ExtendedInfo = "Server Port=" + serverport + ";"
IF HOpenConnection(gctMypostgresql)=False THEN
Error("Unable to connect to database")
END

And this sqlconnect :

gspgdatabase=mydatabase
gspguser = myuser
gspgpassword = mypassword
zserverip=myserverip
gspg_port="Server Port=" + myserverport + ";"

gbConnectionnum = SQLConnect(zeerverip, gsPg_user, gspgpassword, gspgdatabase,"PostgreSQL",hODBC,gspg_port)

But there is no problem when connecting to local database. Is there any code i should add to the native connection string ? Or any suggestion what should i do ?

Thank You