After updating from System.Data.SqlClient to Microsoft.Data.SqlClient in my ASP.NET webforms app, I encountered a problem when trying to run cmd.ExecuteNonQuery(); in this code: protected void Button1_Click(object sender, EventArgs e) { con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].[table]rn ([column])rnrn VALUESrn…
I have a SQL table Templates, which has a column JsonContent. I would like to modify the content of JsonContent with SQL. Each JsonContent has serialized JSON array of objects. For example: [ { "Name":"Test name", "Options":[ { "Name":"1", "Value":1…
Preview: Currently, the Blazor App is accessible via the internet through the public DNS. While registering through the app (which requires db access), two exceptions are thrown in the broswer: SocketException: Name or service not known. SqlException: A network-related or…
I have a report where all the dates should be displayed in the client's time zone. The report includes a feature that allows exporting to Excel. For both generating the report and exporting it to Excel, I am using the…
I have 3 nested DataLists data being loaded from SQL query for each. DataList1_ItemCommand is working properly but DataList2_ItemCommand is not even firing. protected void DataList1_ItemCommand(Object source, DataListCommandEventArgs e) { if (e.CommandName == "Obiectiv") { if (e.Item.ItemType == ListItemType.Item ||…
I have a Laravel project running in a Docker environment, and I'm trying to connect to an SQL Server database. I'm using ubuntu server. However, I'm encountering the following error when executing the query: DB::connection('sqlsrv')->table('Order')->first(); Error Message: IlluminateDatabaseQueryException SQLSTATE[08001]: [Microsoft][ODBC…
I have the following table: CREATE TABLE [dbo].[PRC_Tutors] ( [ID] [int] NOT NULL, [UserID] [int] NOT NULL, [LivelloZoom] [int] NULL, [PosizioneGIS] [nvarchar](max) NULL, CONSTRAINT [PK_PRC_Tutors] PRIMARY KEY CLUSTERED ([ID] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,…
I am trying to enable autoprotect for a SQL Server instance on an Azure virtual machine. I want to do this using a REST call to the Azure API. AUTOPROTECT is disabled I'm using the AzureWorkloadSQLAutoProtectionIntent object and have followed…
We have an Azure SQL table with a column called Description (varchar(1000)). While we loaded data into this table via ADF Pipeline, we used the REST API to create vector embeddings on Description. We used text-embedding-ada-002 model which creates 1536…
I am using the code shown here, to connect to SQL Server. This is working properly, but for the past 2 days, I am facing an issue where multiple connections (~2000) are getting opened and not getting disposed. Due to…