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

[#1]

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.

[#2]

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.

[mago]

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.