1,094 questions
2
votes
3
answers
227
views
SqlConnection.Open works for System.Data.SqlClient and fails for Microsoft.Data.SqlClient with same connection string
I upgraded a library from .NET 4.7 to .NET 8.0.
In doing so, I had to update my System.Data.SqlClient references to Microsoft.Data.SqlClient.
I have both projects open, in different VS sessions, side ...
- 310
0
votes
2
answers
124
views
Support to node crypto module is required - gcloud sql connector
Any idea on what can cause the following issue? We're trying to migrate to the official Cloud SQL Node.js Connector but for some reason I'm getting the following issue when running a test connection ...
- 135
0
votes
1
answer
331
views
Problem creating connection to on-premise SQL Server from PowerBI service
I am looking for some help in creating a connection to on-premise SQL Server. I have tried all the available 2 out of 4 options to get the connection working (basic, Windows) but cannot get it to ...
- 1
1
vote
1
answer
74
views
SQLConnection inside thread stuck finalization thread
We have a class that reads the database in parallel to the main thread.
public class CardHandligSpeedometer : IDisposable
{
private Thread m_Thread;
public CardHandligSpeedometer()
{
...
- 57
0
votes
0
answers
38
views
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server [duplicate]
I'm just new in this sql database, Let say I have pc1 and pc2 so this pc1 is where I published the "Appointment" from vb.net with a sql database and the sql server is also from pc1 and saved ...
- 9
0
votes
3
answers
2k
views
Connection Manager in SSIS task: Keyword not supported: 'ProviderName'
When I'm creating an ADO.NET connection from connection managers of the solution explorer in VS2022, it's all fine. But when I wanna create a connection in the data profiling task of SSIS toolbox, I ...
- 151
0
votes
2
answers
85
views
K8S secret usage in SQLCMD password is always empty
Im trying to connect to an SQL server using K8S secret for password but no matter what syntax or method i want to use the password always empty. If i hard code the password everything works fine.
I ...
- 1
0
votes
2
answers
54
views
ListView Doesn't feed right by SQL select query in ASP.net C#
I have an ASP.net C# site. I feed one of the ListView in that with this code and it's work:
protected void BindData()
{
string forwardedSearchText = Request.QueryString["SearchText"];
...
- 119
0
votes
2
answers
829
views
Trying to install Microsoft.Data.SqlClient fails on .NET 8.0.204
After creating a brand new console project with .NET 8.0.204
When I run:
dotnet add package Microsoft.Data.SqlClient --version 5.2.0
It fails installing the package with the following error:
...
-1
votes
1
answer
1k
views
[unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found
I currently have a late 2011 MacBook Pro, but I've done a few modifications...she now has 2 TB SSD installed internally, along with 16GB of RAM. The OS has been upgraded to Catalina 10.15.7. Im ...
- 41
2
votes
0
answers
81
views
How often do you need to re-create the connection to SQL Server?
I did an experiment with the speed of writing to the database. I have several tables where logs are stored. I took 1 million logs and sent them in batches of 750 records into the database, while ...
- 233
0
votes
1
answer
57
views
How to close .mdf file after used by SqlConnection variable
I'm use SqlConnection variable conn to connect to database1.mdf file. Then I use OpenFileDialog and select file database1.mdf to open, but I get the message
This file is in use
from the ...
0
votes
0
answers
69
views
Problem with connection timeout SQL Server
I'm developing a Windows service in C# that collects data from SQL Server in another machine on the local network.
However, it is necessary to deal with if this other machine is not available, and as ...
- 305
0
votes
1
answer
409
views
Do I need to use Dependency Injection with a simple IDbConnection
I have been using Blazor for about a year and still learning. The app I am developing was setup before I arrived and the decision was made to use a simple IDbConnection to connect to our database. ...
- 57
0
votes
1
answer
58
views
How do I safely take in user input to build another string in my Flutter app?
I need to safely prepare a string that uses user input. I'm using a flutter package called sql_conn to communicate with a SQL database. This is a temporary solution until we build a web server to take ...
- 702