Cannot connect to data source.

Cannot connect to data source.

Posted by: andrei.florian on 11 December 2017, 1:20 am EST

• 

  andrei.florian

  • Post Options:
  • Link
    Copy

  Posted 11 December 2017, 1:20 am EST

  Hi,
  
  I have downloaded ActiveReports Server 12 and I've tried to create a simple report linked to a data source.
  
  First I had created the data source than a data set. in the data set I've called a stored procedure with few parameters.
  
  After I have created them from administration page I've started the web designer to create a report.
  
  In the report I've used the shared data set created above and setup a table to display some columns from the data set.
  
  When I want to preview the report, the designer throw the following error:
  An error(s) occurred
  Cannot connect to data source.
  
  I've recreated the data source and data set again but it not work.
  The connection to the SQL server works and the data set return values, I have no idea how to do it to work. Can you please help me in this matter ?
  
  Regards,
  Andrei
  
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Replied 13 December 2017, 7:15 pm EST

  Hello,
  
  I am able to replicate the problem at our end. I have escalated this to the development team(tracking id 251442) and will revert you back once have any information from them.
  
  Thanks
  Mohit
• 

  andrei.florian

  • Post Options:
  • Link
    Copy

  Replied 11 December 2017, 9:34 pm EST

  Hi,
  
  Thanks Mohit for your feedback.
  
  It's seems that is the same error even if I use a query with parameters.
  
  Regards,
  Andrei
  
  
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Replied 13 December 2017, 6:22 pm EST

  Hello,
  
  I am unable to replicate the second issue with following steps.
  
  1. Create a new data source with "Northwind" database
  2. Create a dataset with query "select * from customers where country=@Country"
  3.Add "Country" parameter in dataset
  4.Create a report with above dataset in web designer
  5.Create a table and bound with associated fields
  6.Preview the report and Enter the "Germany" in parameter field
  
  Could you please provide the steps to replicate the problem at my end.
  
  Thanks,
  Mohit
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Replied 13 December 2017, 6:22 pm EST

  Hello,
  
  I am unable to replicate the second issue with following steps.
  
  1. Create a new data source with "Northwind" database
  2. Create a dataset with query "select * from customers where country=@Country"
  3.Add "Country" parameter in dataset
  4.Create a report with above dataset in web designer
  5.Create a table and bound with associated fields
  6.Preview the report and Enter the "Germany" in parameter field
  
  Could you please provide the steps to replicate the problem at my end.
  
  Thanks,
  Mohit
• 

  andrei.florian

  • Post Options:
  • Link
    Copy

  Replied 14 December 2017, 10:17 pm EST

  Hi Mohit,
  
  It works, i confirm. maybe I do something wrong initially.
  
  What about stored procedures ?
  
  regards,
  Andrei
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Replied 14 December 2017, 10:45 pm EST

  Hello,
  
  >>It works, i confirm. maybe I do something wrong initially.
  That's great.
  
  >>What about stored procedures ?
  Issue has been fixed internally. We will provide you hotfix as soon as available to us.
  
  Thanks,
  Mohit
  
  
  
  

• Marked as Answer

  

  mohitg

  

  • Post Options:
  • Link
    Copy

  Replied 15 December 2017, 8:15 pm EST

  Hello,
  
  Please download the hotfix from the following link:
  https://tinyurl.com/y8k9qlf4
  
  Thanks,
  Mohit