topic Re: Error: safety settings on this computer prohibit accessing a data source on another domain in QlikView

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

Thu, 28 Jul 2011 08:11:57 GMT

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.

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

Anonymous — Sun, 18 Sep 2011 12:52:16 GMT

Hey Nor,

I get the same message from oneof my users.

Have you found a solution?

Best regards

Eran

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

Tue, 20 Sep 2011 07:46:45 GMT

No, I'm sorry. I've created a very dirty workaround to solve this problem and now I don't use a macro but call the procedure in the script.

Nor

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

Thu, 26 Jan 2012 17:22:57 GMT

Hi Norarth and Eran,

Sorry for digging this old post up, but I am currently having the same issue.

Did someone find a solution to use a macro ?

Note : the macro is working when I am connected with the server administrator.

Thanks,

Benoit

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

Anonymous — Mon, 30 Jan 2012 10:57:56 GMT

Hi,

This worked well for me.

Modify the internet options in IE:

Go to Internet options -- Security Tab -- Select Internet and Local Intranet -- click Custom Level (button ) -- Miscellaneous -- select enable for Access data source across domains.

After that I reopened theQLIKVIEW model.

For me it worked..

Good Luck

Eran

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

Mon, 30 Jan 2012 13:40:44 GMT

Thx Eran for your answer, but this solution didn't work for me.

Strangely it is working for the server administrator.

Has anyone another idea ?

Thx

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

ToniKautto — Thu, 02 Feb 2012 09:11:18 GMT

There is a general script setting in QlikView, that will override the Macro Editor access setting. This setting is commonly set the first time QlikView is used to run macros, and is set on a user by user basis hence could generate the different behaviour for different users.

1. Login to Windows with the user you want to change the access right for
2. Open QlikView desktop client
3. Open the QVW application
4. Press Ctrl + Shift + M
5. Change the Macro Module security setting

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

Anonymous — Wed, 19 Sep 2012 07:48:07 GMT

Hi,

I've the same problem...

I access the qvw document by IE pluging how can I set up it to avoid that problem?

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

Wed, 19 Sep 2012 07:58:07 GMT

Hi Matteo,

You will need to open the application on your server and press Ctrl + Shift + M.

You just need to do that one time.

BR,

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

Anonymous — Wed, 19 Sep 2012 08:28:00 GMT

Thank you,

I’ll try as soon as possible.

I hope that help! ☺

Da: benoit_fr

Inviato: mercoledì 19 settembre 2012 09:58

A: Matteo Fioroni

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

QlikCommunity<http://community.qlik.com/index.jspa>

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

created by benoit_fr<http://community.qlik.com/people/benoit_fr> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/260640#260640>

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

Fri, 16 Aug 2013 08:13:51 GMT

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.

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

mago — Wed, 17 Jun 2015 12:06:12 GMT

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.