Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

wmarkett1983
New Contributor II

postgres ODBC connect by macro

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

 

Labels (4)