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!
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 votes0 answersTed Walsh3 weeks 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 Doddapaneni3 weeks 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 Garcia1 month 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 Raj2 months ago
Connection string issue in connecting to SQL Server
I am trying to connect my C# code to SQL Server. My connection string is not working. It gives the following error: "Format of the initialization string does not conform to specification starting at index 0."0 votes0 answersFaizan Rahman3 months ago
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".0 votes1 answerlee avery3 months ago
Remote MySQL Linked Server in SQL Server, only show names of the tables.
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database0 votes0 answersAdrian Feldman3 months ago
connect from Oracle to MS SQL Server
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !0 votes0 answersFrank Lehmann3 months ago
Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data0 votes0 answersRichard5 months ago
how to use regional settings when connecting to SQL Server with a connection string? Is there a parameter for it?
How do i specifiy to use the regional settings (those settings in Windows control panel) for numbers, dates and currency? When defining a DSN connection in ODBC manager Windows i can check to use the regional settings.0 votes0 answersMatthias Rebbe7 months ago
- Load more posts