Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ajax and SQL Connection

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!

4 Replies
gandalfgray
Specialist II
Specialist II

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

Miguel_Angel_Baeyens

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

gandalfgray
Specialist II
Specialist II

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

/gg

Lee_Matthews
Former Employee
Former Employee

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.