Connect Web Designer to SQL Server

Connect Web Designer to SQL Server

Posted by: gci on 20 April 2020, 2:22 am EST

• 

  gci

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 April 2020, 2:22 am EST

  I need to connect a report to sql server. I see that within available providers I have “Microsoft SQL Client Provider” but I got an error when testing the connection. Is this normal o do I have to add custom code in order for this to work ?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 April 2020, 5:34 pm EST

  Hello,

  I am able to connect the MS SQL server through the WebDesigner. Could you please share the error message that you’re facing while connecting the MsSql server.

  Thanks,
  
  Mohit

• 

  gci

  • Post Options:
  • Link
    Copy

  Posted 21 April 2020, 12:16 am EST - Updated 30 September 2022, 6:37 am EST

  Hi,

  I followed the example here: https://www.grapecity.com/activereports/docs/v14/online/how-to-create-simple-web-designer-sample.html

  Whe I try to connect to SQL, I got the attached error.

  

  1702×602 52 KB

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 21 April 2020, 6:53 pm EST

  Hello,

  Could you please refer the following sample to check at your end:
  
  https://github.com/activereports/WebSamples14/tree/master/WebDesignerSamples

  If the issue is still reproducible, could you please share the sample with me.

  Thanks,
  
  Mohit

• 

  gci

  • Post Options:
  • Link
    Copy

  Posted 22 April 2020, 1:05 am EST - Updated 30 September 2022, 6:37 am EST

  Hi

  I’ve checked these examples. The MVC project seems to work as expected. I could connect to my data source and run a few reports.

  On the other hand, MVC-Core one (which I could be interested in implementing) shows a license error when run it. I’ve seen this error in one of the posts and included the licx file within properties folder but it still does not work. Images attached:

  

  1413×615 17 KB

  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 22 April 2020, 1:36 am EST

  Hello,

  Could you please run your application in VS2019 as AR support .Net core only in VS2019.

  Thanks,
  
  Mohit