postgres ODBC connect by macro

wmarkett1983 — Sat, 16 Nov 2024 04:45:20 GMT

Hello,
i am able to connect the local postgres database by the load script, by excel macro, but not by qlikview macro.

Excel Makro (running):

Set objDb_con = CreateObject("ADODB.Connection")
glbConnString = "Driver={PostgreSQL Unicode};Database=postgres;server=localhost;UID=postgres;Pwd=Password"
objDb_con.Open glbConnString

QlikView Marko (not running):

sConn="provider={PostgreSQL Unicode};data source=localhost;location=postgres;"
Set oConn = CreateObject("ADODB.Connection")
MsgBox "Connect"
oConn.Open sConn, "postgres", "Password"
MsgBox "ConnectDone"

The red marked line is not executed, but i dont know what the error is. Anyone an idea how to get more insights?

Thanks in Advance

topic postgres ODBC connect by macro in QlikView

postgres ODBC connect by macro