All Questions
122 questions
0
votes
2
answers
294
views
When connecting to the mysql database, an exception appears
can anyone help me, I am trying to connect mysql database, the server details are entered correctly, but when I call the open method, the program throws an exception.
I also used Server explorer, in ...
- 3
0
votes
0
answers
42
views
Can't use MySqlConnection methods outside function
I am new coding and I am trying to create a model DBContext.
I instantiated a connection conn using MySqlConnection. Then I perceived it didn't me allow to use conn methods (like conn.Open()).
I have ...
- 171
1
vote
0
answers
226
views
.Net5 Call stored procedure in MySql with OUT parameter
I'm trying to call a Stored Procedure in MySql that returns a list of rows and with OUT parameter. Code:
using (MySqlConnection conn = new MySqlConnection("server=***;database=***;uid=***;pwd=***;...
- 42
2
votes
2
answers
1k
views
Connection error to localhost database c#
Hi I'm trying to connect to a database using System.Data.SqlClient. I think I have everything correct, but for some reason Visual Studio gives out an error:
EDIT:
It turns out I was dumb and using ...
- 79
0
votes
2
answers
264
views
Database data Not updating
I am trying to update my details in Database.
Below here is the code I have written.
The Problem I am facing is, the details is not updating in the database instead of the program running successfully....
- 11
0
votes
0
answers
389
views
parameter '@xxx' has already been declared
Here i am trying to update the details in my mysql database, but its not updating the details but showing done. After that if i try to update the same thing its is showing Parameter '@Unique ID' has ...
- 11
0
votes
0
answers
74
views
Using multiple, MySqlConnection objects concurrently, for the same connection string, throws exceptions
My code looks like this:
void SomeFuncCalledConcurrently()
{
using(var connection = new MySqlConnection(mConnectionString))
{
connection.Open();
//DoStuff
connection.Close();
...
- 2,665
0
votes
0
answers
134
views
how do I avoid the startup delay when I connect to a MySQL database using c# system.data.mysqlclient visual-studio on mac
Is there a way to force sql connection when the connection is open.. For the first time I wait 20 seconds to display the data.. after that everything is ok..
I use system.data.mysqlclient library for ...
- 496
0
votes
0
answers
198
views
Why I can not connect to MySql .Net with Driver connection String as it works with Delphi's TADOQuery?
I have Connection string like this:
Driver={MySQL ODBC 8.0 Unicode Driver}; Server=localhost; Database=data; UID=root; Password=admin;
My program written in Delphi connects right. But the same ...
- 63
0
votes
0
answers
167
views
How to configure MySql NET Connector with SSH (having a working connection in MySql Workbench)
EDIT: Solution found - details to be found below.
I have a configured connection in MySql Workbench which works fine, but when I try to connect using C# in Visual Studio, the connection reaches ...
- 23
0
votes
1
answer
2k
views
C# MySQL MySqlConnection connectionstring for empty password [duplicate]
I am trying to connect C# and database MySQL : using MySql.Data.MySqlClient;
My codes are as below. I am getting error. I think it is because of empty password.
string connstring = @"server=...
- 65
0
votes
0
answers
182
views
having trouble connecting Visual studio 2019 with MySQL database and inserting user input in textboxes into said database (solved)
i am using Visual Studio 2019 and MySQL workbench, i've created a database specifically for the program, and also created a table for collecting user info. what i want to do is have the user input ...
0
votes
1
answer
102
views
Failed to connect to MySQL localhost server Win32Exception
I am trying to connect to the database from simple console-application (C#) to localhost that is running from WAMP server. I have tried with multiple string Connections but neider works
usings:
...
- 145
0
votes
0
answers
447
views
Can't connect C# WinForm to an Online DataBase
I am using the below code for connecting to SQL Server on 2 different laptops and is working only on just one. On the other one, it shows up the next error:
Application.exe Error: 0 : Unable to ...
- 39
0
votes
1
answer
208
views
Socket Exceptions when trying to connect to MySql database from gitpod IDE (ubuntu server)
I'm working with the gitpod online IDE ( vs code in the browser with an ubuntu linux server behind it).
I'm struggling with creating a Connection to my mysql database on an other linux (CentOS) server....
- 106