DllCall problem

[noknown]

I have libpq PosgreSQL library

I wrote this example code:

Local $Conn = DllCall(@ScriptDir & "\libpq.dll","int","PQlibVersion","none","")
If @error Then
    MSGBox(64,"@error",'Error DllCall: ' & ' Error: ' & @error & ' Extended: ' & @extended & @CR)
EndIf

@error is always 1. 

I've tried change path to this dll, tried change types of parameters from "int" to "int*" and from "none" to "none*", tryed change function call type to :cdecl... - nothing. 

What I'm Doing Wrong?

I just need to access my PostgreSQL database without ODBC (user have no admin rights to install it). 

[UEZ]

Try

Local $Conn = DllCall(@ScriptDir & "\libpq.dll","int","PQlibVersion")

or if cdecl calling method

Local $Conn = DllCall(@ScriptDir & "\libpq.dll","int:cdecl","PQlibVersion")

 

Edited September 12 by UEZ

[noknown]

1 hour ago, UEZ said:

Try

Local $Conn = DllCall(@ScriptDir & "\libpq.dll","int","PQlibVersion")

or if cdecl calling method

Local $Conn = DllCall(@ScriptDir & "\libpq.dll","int:cdecl","PQlibVersion")

 

Unfortunately hadn't work, but thanks!

[UEZ]

Maybe there are some dependencies missing (exports) for libpq.dll

WS2_32.dll
libintl-9.dll
Secur32.dll
WLDAP32.dll
libssl-3-x64.dll
libcrypto-3-x64.dll
KERNEL32.dll
SHELL32.dll
ADVAPI32.dll
VCRUNTIME140.dll
api-ms-win-crt-heap-l1-1-0.dll
api-ms-win-crt-convert-l1-1-0.dll
api-ms-win-crt-string-l1-1-0.dll
api-ms-win-crt-stdio-l1-1-0.dll
api-ms-win-crt-runtime-l1-1-0.dll
api-ms-win-crt-environment-l1-1-0.dll
api-ms-win-crt-time-l1-1-0.dll
api-ms-win-crt-utility-l1-1-0.dll
api-ms-win-crt-math-l1-1-0.dll
api-ms-win-crt-locale-l1-1-0.dll
api-ms-win-crt-filesystem-l1-1-0.dll

because

DllOpen(@ScriptDir & "\libpq.dll")

returns -1 which is not ok.

[noknown]

1 hour ago, UEZ said:

Maybe there are some dependencies missing (exports) for libpq.dll

WS2_32.dll
libintl-9.dll
Secur32.dll
WLDAP32.dll
libssl-3-x64.dll
libcrypto-3-x64.dll
KERNEL32.dll
SHELL32.dll
ADVAPI32.dll
VCRUNTIME140.dll
api-ms-win-crt-heap-l1-1-0.dll
api-ms-win-crt-convert-l1-1-0.dll
api-ms-win-crt-string-l1-1-0.dll
api-ms-win-crt-stdio-l1-1-0.dll
api-ms-win-crt-runtime-l1-1-0.dll
api-ms-win-crt-environment-l1-1-0.dll
api-ms-win-crt-time-l1-1-0.dll
api-ms-win-crt-utility-l1-1-0.dll
api-ms-win-crt-math-l1-1-0.dll
api-ms-win-crt-locale-l1-1-0.dll
api-ms-win-crt-filesystem-l1-1-0.dll

because

DllOpen(@ScriptDir & "\libpq.dll")

returns -1 which is not ok.

Big thanks to you! It may be the solution. I'll try to find all dependecies and write the result here!

[noknown]

On 9/12/2024 at 5:29 PM, UEZ said:

Maybe there are some dependencies missing (exports) for libpq.dll

WS2_32.dll
libintl-9.dll
Secur32.dll
WLDAP32.dll
libssl-3-x64.dll
libcrypto-3-x64.dll
KERNEL32.dll
SHELL32.dll
ADVAPI32.dll
VCRUNTIME140.dll
api-ms-win-crt-heap-l1-1-0.dll
api-ms-win-crt-convert-l1-1-0.dll
api-ms-win-crt-string-l1-1-0.dll
api-ms-win-crt-stdio-l1-1-0.dll
api-ms-win-crt-runtime-l1-1-0.dll
api-ms-win-crt-environment-l1-1-0.dll
api-ms-win-crt-time-l1-1-0.dll
api-ms-win-crt-utility-l1-1-0.dll
api-ms-win-crt-math-l1-1-0.dll
api-ms-win-crt-locale-l1-1-0.dll
api-ms-win-crt-filesystem-l1-1-0.dll

because

DllOpen(@ScriptDir & "\libpq.dll")

returns -1 which is not ok.

In fact, I only needed one of the dependencies: libintl-9.dll 

Spoiler

which is found at C:\Program Files\PostgreSQL\16\pgAdmin 4\runtime

Thank you very much! Marked your answer as  the solution.

Edited Saturday at 10:17 AM by noknown