1,740 questions
0
votes
0
answers
101
views
sqlcmd cannot connect to LocalDB (MSSQLLocalDB) even though instance is running
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 ...
- 370
0
votes
0
answers
25
views
InstallShield issue SUPPORTDIR using
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\...
1
vote
1
answer
62
views
VB.NET winforms SQL Server Express - aggregate query to variable
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 ...
0
votes
1
answer
410
views
SQL Server 2022 Express logs the message: RBPEX::NotifyFileShutdown: Called for database ID, database not accessible
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 ...
0
votes
0
answers
31
views
ASP.NET MVC upload an image and save it to database
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....
- 1
1
vote
1
answer
126
views
Format of the initialization string does not conform to specification - using same string for EF that worked for SqlClient
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 ...
- 57
1
vote
0
answers
226
views
ASP.NET Core 8 SignalR and Angular 8 integration: no messages after SQL Server database changes
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 ...
0
votes
0
answers
39
views
checking if SQL Express installed in Inno Setup [duplicate]
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'...
- 3,052
0
votes
1
answer
239
views
GNUCobol 3.2.0 Copybooks
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 ...
0
votes
0
answers
210
views
Error -2147217887 connecting to SQL Server Express using MSOLEDBSQL in Excel VBA
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 ...
0
votes
0
answers
391
views
Connect Budibase to SQL Server?
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 (...
- 51
0
votes
0
answers
458
views
Access localhost SQL Server Express from within docker container running in docker-desktop
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 ...
- 1,382
0
votes
1
answer
497
views
SQLPackage failing to login on azure DevOps pipeline
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 &...
- 6,653
0
votes
0
answers
113
views
Import Data from XLSX
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 ...
- 13
0
votes
0
answers
39
views
How to make container communicate with SQL Server on host machine [duplicate]
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 ...
- 3,469
0
votes
0
answers
195
views
How to solve “SqlClient connection fails when ran in Docker Desktop”?
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 =...
- 11.7k
0
votes
3
answers
1k
views
Cannot connect to local SQL Server Express from my ASP.NET web app
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, ...
0
votes
2
answers
950
views
Cannot access SQL Server Express on Mac using Docker
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 ...
1
vote
0
answers
221
views
INSERT INTO linked server on Trigger OLE DB provider "Microsoft.ACE.OLEDB.16.0" for linked server does not support the required transaction interface
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 ...
0
votes
0
answers
199
views
.Net error connecting to SQL Server in docker container
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 ...
- 179
0
votes
1
answer
108
views
MS-SQL Server query to find record where column row is part of nominated string using Classic ASP
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 ...
user16674741
0
votes
1
answer
655
views
Raspberry Pi Debian 11 looking how to connect to SQL Server through python
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 ...
- 1
0
votes
1
answer
1k
views
Convert instance name in SQL Server 2022 [closed]
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 ...
- 5,176
0
votes
2
answers
171
views
Blazor WASM SqlException: Cannot insert explicit value for identity column in table 'Categories' when IDENTITY_INSERT is set to OFF
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 ...
0
votes
1
answer
482
views
Excel VBA - Insert worksheets into SQL Database
Hello im new to VBA and im struggling a bit, so i need your help.
About the requirements:
Every day a special csv file is updated by our CRM.
From this Excel table 4 columns are to be written into a ...
- 259