Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor II

postgres ODBC connect by macro

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


Labels (4)