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