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.
Is this referring to the setting I made? What should I do?
Waiting for your views.
Thanks in advance.