Hello,
Is it possible to use in SharePoint Webpart; SQL DataSource as Infragistics Report DataSource (.igr) ? I'm getting this error when I try to add SQL connection to igr Report using the DataSource Configuration Wizard: "Connection could not be added."
Is it possible to modifiy igr code an specify connectionString ? or SQL connection settings must be in the web.config ?
Are there any exemples ?
Hello gtarek,
It's hard to give an accurate answer without knowing how your project is structured. I think you should consider where your WebPart is going to be deployed before deciding where you want to save your connection string. If its going to be deployed in a SharePoint site, you will have to copy the connection string settings from your project's web.config to the SharePoint site manually.
A more straightforward option could be clearing the check box labeled "Save the connection string with the following name" in the Data Source Configuration Wizard second step. By using the approach before, the connection string will be stored in the IGR file.
Please let me know if this answer was useful to you.
Regards,
Damián