Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error: safety settings on this computer prohibit accessing a data source on another domain

In a macro I am calling a procedure in the oracle database. In the developper it works correctly, but after deploying and accessing via IE I get the message "safety settings on this computer prohibit accessing a data source on another domain".

I've enabled "access datasources across domains" in the internet options on the client.

In the module editer I've set "allow system access" and "system access".

The macro looks as follows:

sub WriteToDatabase

dim sConn, oConn

    Set oConn = CreateObject("ADODB.Connection")

    sConn = "Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=" & vUserID & ";Password=" & vPassword & ";Data Source=" & vDataSource & ";"

    oConn.Open sConn

    sSQL="procedure_name('" & var1 & "'),'" &  var2 & "')"

   

    oConn.Execute(sSQL)

    oConn.Close

    Set oConn = Nothing

end sub

Note: the called procedure writes in the database.

Any ideas how to prevent this message?

Thanks, Nor.

11 Replies
Not applicable

open ie borwser and go to your document.(not on the server, on the web)

when you are in the document press Ctrl + Shift + M

then select "Give System Access to Module Script" and click "OK".

that's all.

Capture.PNG

mago
Contributor
Contributor

Hi everyone,

I've had the same issue trying to write values into a database from QV, It works if you are using IE plugin but Ajax doesn't.

So, after work around it, i've found the solution, just allow unsafe macro execution on server (System, QVS, Security, Miscellaneous), now, our application can write into a Oracle and MS Access database.

I hope it helps someone.

Regards.