Form, SQL and SSRS

BSA_AQ 10 Reputation points
2023-01-16T22:28:37.18+00:00

Good morning.

I am working on a project for the Maori Health Department. The request process for the services of the Maori Health Department is paper-based, so they want to automate the process by creating a Webpage where the customer can make the request.

 

Also, they have several request paper forms which should be automated. The IT Department will create the Webpage, but the Maori Department staff will create and update their forms based on the requested paper forms. In this way, they can change their forms when necessary.

 

The solution or software to create the form should be:

 

 1) Easy to use.

The forms will be called from the web page.

 

2)Ability to connect to SQL database and save the information

 

  1. Ability to connect to SQL Server Reporting Server to create reports and statistics.

 

I checked MS Forms; some articles said that it is impossible to connect to s SQL database, while others said it is possible using a second SQL connection. If someone can explain more about that, it would be good because I couldn't understand it.

 

Also, I saw a video of MS Azure in which the trainer creates a form and connect it with a SQL database. I talked with some colleagues, and we need this option available in our AZURE. How can I activate these options?

 

Thanks in advance for your help.

 

Regards,

Business System Analyst from Health New Zealand.

 

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
719 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,001 Reputation points
    2023-01-17T06:43:19.7366667+00:00

    I checked MS Forms; some articles said that it is impossible to connect to s SQL database,

    I wonder about that statement. Of course any kind of client application (WinForms, WebForms, WPF, etc) can connect to a MS SQL Server or any other RDBMS, it's just a question of the used DAC = Data Access Component

    1 person found this answer helpful.
    0 comments
  2. BSA_AQ 10 Reputation points
    2023-02-08T20:46:47.8533333+00:00

    Hi Olaf

    Thanks for your help.

    Regards,

    Maria Ramirez

    1 person found this answer helpful.