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