Skip to main content
1,742 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
1 answer
61 views

I'm writing a web application that should use EF Core to handle a SQL Server Express server database (the application is called RRDA). The solution is divided into 3 projects: RRDA.Web (the web ...
weirdgyn's user avatar
  • 1,048
0 votes
2 answers
107 views

I'm trying to get a C++ application to connect to a SQL Server database on another computer. But I've found that I can't even connect using SQL Server Management Studio. So I must have something wrong....
KokoCa's user avatar
  • 241
0 votes
0 answers
129 views

I have a fresh installation of SQL Server 2022 LocalDB. When I try to initialize a database with a script using the command: sqlcmd -S (localdb)\MSSQLLocalDB -E I get the following error: No named ...
Ait Yahia Idir's user avatar
  • 370
-1 votes
1 answer
105 views

I have a SQL script written by someone that uses outer apply on a function. I think a code generator WYSIWYG was used , I thought that all the CAST's was making it more stable, but apparently just ...
Robert's user avatar
  • 13
0 votes
0 answers
31 views

I encountered the following issue in InstallShield 2016: I'm trying to use SUPPORTDIR to place my executable file there. However, when I open the SUPPORTDIR folder (e.g., C:\Users\user-name\AppData\...
Igor Soom's user avatar
  • 1
0 votes
0 answers
52 views

I have a question and I need help solving an issue. I have an installshield 2016 installation and I want to allow the user to either select an existing SQL Server database (and then the installation ...
Igor Soom's user avatar
  • 1
1 vote
1 answer
67 views

I've searched again and again. Have a solution but must be easier way. Currently, I'm writing a SQL command to cycle through records for min value as first using the code below. As you can see, I am ...
Donald Whittaker's user avatar
  • 11
1 vote
1 answer
52 views

I have to restore a SQL backup from someone external and have the following issue: Instead of making a nice single big file for the entire instance of SQL, I have a folder with 100+ individual ...
asdfmoin's user avatar
  • 31
0 votes
1 answer
463 views

Our SQL Server log contains multiple messages for every database installed in the instance: RBPEX::NotifyFileShutdown: Called for database ID.... There is no error message about this in the window ...
willemjan putto's user avatar
  • 1
0 votes
1 answer
121 views

I'd like to pull some data into SQL Server Express, from a high-current electrical test machine running SQL Server. The first problem I'm experiencing is that I can't get replication setup, because ...
david's user avatar
  • 2,706
0 votes
0 answers
32 views

I am trying to upload an image to save it to SQL Server Express. This is my view: @model Nettbutikk.Models.ProductsModel @{ } @Html.Raw(ViewBag.msg) @using (Html.BeginForm()) { @Html....
javed's user avatar
  • 1
0 votes
1 answer
49 views

I am trying to display an image in a view. Here I add an image in SQL Server Express (price is defined as int and picture is a varbinary(MAX) column): insert into products (price, picture) select ...
javed's user avatar
  • 1
1 vote
1 answer
131 views

I am transitioning from code that uses Microsoft.Data.SqlClient to Microsoft.EntityFrameworkCore in .NET Core 8.0. I have a connection string that successfully connects to a local SQL Server Express ...
perihelions's user avatar
  • 57
0 votes
1 answer
52 views

I'm trying to connect to a local SQL Server Express database, but when I submit a form using my .cshtml.cs page, the data doesn’t appear in the table after the command executes. I’m not sure if this ...
Fraxx's user avatar
  • 1
1 vote
0 answers
234 views

I’m currently working on a project involving an ASP.NET Core 8 application with SignalR for real-time notifications with SQL Server, an Angular 18 frontend, and SQL Server 2022 Express edition as the ...
Mohamed Abdelrahman's user avatar
  • 33
0 votes
0 answers
222 views

I am learning SQL Server on my Windows 7 Laptop. And I am trying to install SQL Server Management Studio, I have already installed SQL Server Express and Local DB. Whenever I try to install SSMS on my ...
Basel Alaa's user avatar
  • 11
0 votes
0 answers
40 views

I am trying to figure out that SQL Express is installed on Machin in Inno Setup. so I did this res:= RegQueryStringValue(HKLM, 'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL', 'SQLEXPRESS'...
nnmmss's user avatar
  • 3,052
-1 votes
1 answer
496 views

I am using Visual Studio 2022 (VB.Net) and SQL Server 2022 Express. I am not a programmer; I just like teaching myself coding and trying to learn. I have a program, and I am trying to access the data ...
Kevin's user avatar
  • 107
0 votes
1 answer
253 views

I am working with GNUCobol cobc version 3.2.0 It seems that COPYBOOKS do not work during the compile step? The source code is going through the esqlOC precompiler first. I have these to lines COPY ...
David Wulkan's user avatar
  • 1
0 votes
1 answer
62 views

Wondering if anyone else is running into an issue with Entity Framework Core throwing an error when reading data from a local SQL Server Express instance that's running on an m1 mac and Parallels? I ...
HKiernan's user avatar
  • 65
0 votes
0 answers
218 views

I'm trying to connect to a new SQL Server Express database (SQL Server 16.0.1000) and I can establish the connection with a .BAT file and also SSMS, but not in VBA. The name in SQL Server Management ...
S. Jagermanjensen 's user avatar
  • 1
0 votes
1 answer
296 views

I have an SSIS package which contains a Script Task, Execute SQL Task and File System Task inside of a Foreach Loop container. I can execute the package without issue in Visual Studio, but when I try ...
Kevin O's user avatar
  • 1
0 votes
0 answers
402 views

I have been trying to connect Budibase to SQL Server but all in vain. I have enabled the SQL Server Browser and SQL Server (SQLEXPRESS), however, I have failed to enable the SQL Server Agent (...
Steven's user avatar
  • 51
-1 votes
3 answers
80 views

I have a table with multiple address columns Address1 | Address2 | Address3 | Address4 | City | County | PostCode Address1 and PostCode will always be populated, the other columns may contain null. I ...
Reg J's user avatar
  • 7
0 votes
0 answers
466 views

My DB connection string uses this: Data Source=.\\sqlexpress; to point to the DB, this works when running the project diectly but not when running it inside docker locally using docker-desktop. I ...
buga's user avatar
  • 1,382
0 votes
0 answers
92 views

I am trying to email the results of a query to myself in the case that someone else is running a stored procedure and an error occurs. This script is part of a larger program that generates schema, ...
Hyper10n's user avatar
  • 49
0 votes
1 answer
501 views

Lately (since around 15/02/2024) in around half of the pipeline runs the SQLPackage executable fails to fully connect to the mssqllocaldb server that is started in a previous step. The main error is &...
nick zoum's user avatar
  • 6,653
-2 votes
1 answer
104 views

Say we have the following SQL Server table date, qty, debit I want to calculate a NewDebit value based on the formula shown here. I have tried everything - grouping, partition, cte - it is just not ...
Stelios's user avatar
  • 340
0 votes
0 answers
118 views

I'm trying to import data from an Excel file into Microsoft SQL Server 2019 Express Edition (64-bit) using the following query USE DB1; GO EXEC sp_configure 'show advanced options', 1 RECONFIGURE WITH ...
Paksos's user avatar
  • 13
0 votes
1 answer
223 views

I'm creating a database for a rentals system for musical instruments where I want an email sent to the administrator when the residual value of an instrument is zero or less than zero. An earlier ...
RobPL's user avatar
  • 61
0 votes
0 answers
39 views

I am running an ASP.NET application in a Docker container. This application communicates with SQL Server Express which is running on the host. When I run this application, obviously it throws an error ...
Frank Martin's user avatar
  • 3,477
0 votes
0 answers
43 views

The problem is when I run the setup.msi, RESTORE DATABASE terminate abnormally error code is returned but when I run the query in ssms, it's working fine. Is there any limitation of sqlstring element? ...
masterhei's user avatar
  • 1
0 votes
0 answers
200 views

I'm attempting to connect to a local SQL Server Express instance I have on my dev box. I'm using the following code: var cs = new System.Data.SqlClient.SqlConnectionStringBuilder(); cs.InitialCatalog =...
Paulo Santos's user avatar
  • 11.7k
0 votes
2 answers
726 views

I need pointing in the right direction as I seem to have hit a brick wall. I am getting the following error when I try to synch on subscriber on one of the laptops: Type : Microsoft.SqlServer....
lardymonkey's user avatar
  • 778
0 votes
3 answers
1k views

I am developing an ASP.NET web app on my Windows 11 machine. I have set up SQL Server Express to accept tcp connection, tested it using dbeaver and able to connect successfully. But when I run my app, ...
Aryabhima A. Rahman's user avatar
  • 415
1 vote
1 answer
1k views

I've been working through this for nearly two days and I'm running out of options. Maybe you guys can help. Background: I migrated a .netcore api from Windows to WSL2 (Ubuntu 20.04). My Database is ...
gin93r's user avatar
  • 1,623
0 votes
2 answers
960 views

I use Visual Studio 2022 on Windows Parallels on a MacBook Pro M2 chip. My goal is to use SQL Server Express on Windows Parallels. I found this guide: https://kb.parallels.com/en/129699 I was able to ...
Joseph Anderson's user avatar
  • 1
0 votes
0 answers
51 views

I am getting the following Error in this parameterized query using Classic ASP. ADODB.Command error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one ...
Babar's user avatar
  • 75
1 vote
0 answers
226 views

I have created a stored procedure, which among other things contains and INSERT into an Access linked server. I want to trigger this stored procedure upon INSERT into an SQL table. If I run the stored ...
Matt Crumpler's user avatar
  • 11
1 vote
0 answers
44 views

SQL Server Express. My table 'weather' contains two relevant columns: snapdate (date) temp (decimal 18,2) snapdate contains a date like 2023-07-30 My query is intended to return the maximum and ...
Jacques's user avatar
  • 33
0 votes
0 answers
200 views

I have 2 docker containers, one with sqlexpress and one with my asp.net app. Both of these containers are in the same network and see each other. I can connect to the database from the host machine ...
Paul Vinogradov's user avatar
  • 179
0 votes
0 answers
816 views

I have a deployment of MS SQL Express 2019 on a Windows 10 machine and I want to disable SQL Automatic updated (any update it may receive). How to do it? Thanks
Luka's user avatar
  • 4,211
0 votes
1 answer
110 views

The query needs to find a record where the value stored in a column row matches the nominated variable. For example the column row value might be https://example.com/docs/ and the nominated url might ...
user avatar
0 votes
0 answers
53 views

Before getting into the subject, I would like to say that before getting to this problem I had to solve another one that I asked in the this link. Thanks to Erland Sommarskog, I think I have solved a ...
Aarón BD's user avatar
  • 3
0 votes
1 answer
665 views

I have tried multiple ways to create a connection but have been unsuccessful. I have attempted to install unixobdc. I get it downloaded but I cannot seem to get a driver... I am unsure what I am doing ...
KShaw's user avatar
  • 1
0 votes
0 answers
118 views

I am trying to fetch an object from an SQL-Express DB, map a new object to the it using AutoMapper, and then save changes to the DB with the updated properties. The source class properties: public int ...
Avshalom's user avatar
  • 1
0 votes
1 answer
1k views

I use a VM with a fresh installed SQL Server 2022 Express. Also installed latest SSMS 19. Normally I can refer to local databases as localhost. But it is not available. The only way to access local ...
Roland Bengtsson's user avatar
  • 5,176
0 votes
0 answers
168 views

I'm trying to access into a database in SQL Server 2019 Express from my old Delphi 7 project that still using BDE and SQL Server as Driver name (for migration only). With the db1 (tDatabase) setting ...
Jasen's user avatar
  • 1
0 votes
2 answers
173 views

Sorry for posting what might seem a duplicate but please bear with me! My first time working on a Blazor .NET Core applications with Entity Framework. My project is based of Thomas Beck's project from ...
Eliya Amanoeel's user avatar
  • 63
0 votes
0 answers
271 views

I am building an application that uses SQL Server Express as backend and a frontend of MS Access. I am trying to store small pdf files in the database using the varbinary(max) column type. I am ...
DoShawhan's user avatar
  • 1

1
2 3 4 5
…
35