Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Contributor II
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)
0 Replies