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…
I have the following 2 tables: Person ------ PersonId int PK Name varchar ThingCollectionId int ======================= PersonId Name ThingCollectionId 1 Joe 100 2 Mary 101 3 Dave 102 Thing ----- ThingId int PK ThingCollectionId int Name varchar ======================= ThingId ThingCollectionId…
I'm trying to take a SQL query and turn it into JSON for an API call. I have two groupings that need to contain an opening and closing bracket [] because they can contain multiple rows. Those are shown here…