Error seen while acquiring data from the SQL database
I wanted to secure and acquire data from the SQL database using the code I have written in CRM 4.0, but it comes up with an error. I allowed the data connection through disabling the firewall, but got the same result.
Here is the code that I have written.
Please make any comments about the codes.
Could someone analyze this for me?
var connection = new ActiveXObject("ADODB.Connection") ;
varconnectionstring="Data Source=SVT-SRV-02;Initial Catalog=SynovergeTest_MSCRM;Integrated Security=True;Provider=SQLOLEDB";
varrs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT distinct top 1 ModifiedOn,CustomerIdName FROM Opportunity where StatusCode='3' and DeletionStateCode = '0' order by ModifiedOn DESC", connection);
Upon executing the codes, the screenshot below appeared.
Message from webpage
There was an error with this fields customized event.
Error.Safety settings on this computer prohibit accessing a data source on another domain.
Is this referring to the setting I made? What should I do?
Waiting for your views.
Thanks in advance.