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…
I have installed a .Net Framework 4.5.2 Web app into Azure, which is set up to use Entra authentication. The app needs to connect to a SQL Server database in the Azure account. The Azure UI shows a variety of…