topic Ajax and SQL Connection in QlikView

Ajax and SQL Connection

Mon, 29 Aug 2011 23:44:09 GMT

Hello,

Some macros seem to work with ajax zero footprint as long as the browser is IE, such as popups, but I am having issues with some functionality. Inserting information into a database using some sql in a macro does not seem to work - Does anyone know the limitations for macros with ajax zero footprint? Is there a way to make a connection and insert data to sql server without the plugin?

Thanks!

Ajax and SQL Connection

gandalfgray — Tue, 30 Aug 2011 07:23:52 GMT

Hi Tyler

I am not sure but to my understanding in Ajax ZFC:

macros doing stuff with the GUI will work

macros accessing disk or databases wont work

/gg

Ajax and SQL Connection

Miguel_Angel_Baeyens — Tue, 30 Aug 2011 08:17:20 GMT

Hi there,

Something like that, although any kind of object (a MsgBox for example) will not be rendered in Ajax Zfc since it has not the drawing functions the OCX (Plugin) has.

Anyway, did you check that your macro is granted "System Access" and "Allow System Access" in the module editor (Ctrl + M). Again, there are some macros that simply don't work in the Ajax client.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Ajax and SQL Connection

gandalfgray — Tue, 30 Aug 2011 08:21:38 GMT

Yes, and I think none of the macros that needs system access will work in Ajax ZFC anyway.

/gg

Re: Ajax and SQL Connection

Lee_Matthews — Thu, 30 Aug 2012 02:36:30 GMT

I stumbled across this old post while searching for something else. I just thought I would add a quick note to clarify things in case someone is misled. Yes you can write to a database using AjaxZFC. Here is an example application showing one possible way you could do it. http://community.qlik.com/docs/DOC-2784

As mentioned above you will need to grant system access to the macros.