Where to place Connection String of SQL Server (hosted on Azure) in Web Forms Website
I am trying to use Microsoft Azure to host an ASP.NET Web Forms website, and connecting an SQL Server database (also hosted on Azure) to it.
- I created the SQL Server database and have added a table to it, using Microsoft SQL Server Management Studio
- I have published the website, and it is currently hosted on Azure.
- When I created the website, I linked the above SQL database to it. So the database table displays in 'Server Explorer' in Visual Studio when I open my website.
My problem now is that I don't know how to retrieve (SELECT) data from the database table, and display it on the website.
On Azure portal, I found the Database connection strings (ADO.NET (SQL authentication)), but I don't know where I need to copy and paste this connection string within my project.
Can someone please help me and advise me how to proceed?
Thanks a lot in advance!
Azure SQL DB connection string is not working unless logged in to azure account
I'm building an Visual C++ project which is connected to Azure SQL database via ODBC, I placed the following connection string that Azure:0 votes0 answersAhmed Ayman3 weeks ago
Making Constant Data Bases to recall in program.
I'm a student learning programming. I need to find out what web address gets my database and server. I need to find out what the database name is.0 votes0 answersBrad Harris3 weeks ago
Connection error IIS10/SQL 2016
I try to transfer a classic-asp-application from Windows Server 2008R2/II7 to 2016/II10 and SQL 2008 to SQL 2016. The application works fine with IIS10 and SQL 2008. Also with IIS7 and SQL 2016.0 votes0 answersPaul H. Niederbracht3 weeks ago
SSIS package with ODBC source Teradata Deployment issue
SSIS package works fine in Visual Studio, But when deployed it says gives error, SQL Jobs fails execution0 votes0 answersSandesh J1 month ago
JDBC additional parameters for Azure SQL
Hi, I am trying to connect my existing ETL application with Azure SQL Database. But since 29th July 2019, I am getting error Connection Reset/Connection is closed.0 votes0 answersTamanna Sharma1 month ago
Connect to SQl with gMSA
I'm trying to make use of gMSA's to connect from ASP/X code to an MS SQL 2016 server. I've configured the gMSA with permissions on the target database and set up the gMSA on the source server, but can't get a connection string configured to use the account.0 votes0 answersSteve Sirag2 months ago
SSIS SMO Connection String?
does anyone have a connection string for SSIS SMO that will connect to an Azure Database using Active Directory Authentication?0 votes1 answerTed Walsh4 months ago
Azure SQL, Mulesoft
Hi Everyone, I have a use case where i need to connect to Azure SQL Server Database which is hosted on cloud and i can able to connect through SSMS by providing username password and authentication0 votes0 answersAneesh Doddapaneni4 months ago
Non-Standard Port with SQL Server ODBC
Why does the SQL Server ODBC Connection page not mention any example of using a non-standard port? I was incorrectly trying to use the "Port" attribute as "Port=x" but that does not work.0 votes0 answersDavid Garcia5 months ago
NUODB to SQL database migration
Hi Guys I am using SQL Server 2012 , using import and export wizard i want to migrate nuodb databse to sql , but could not find any JDBC data source inside the wizard.0 votes0 answersGautam Raj5 months ago
- Load more posts