Stack Overflow
Stack Overflow

Questions tagged [connector-net]

MySql Connector/NET is the open source ADO.NET provider supported by Oracle for MySql databases.

37 questions
21
votes
9 answers

The ADO.NET provider with invariant name 'MySql.Data.MySqlClient' is either not registered in the machine or application config file

I have an asp.net solution using entity framework 6 to mysql server. now I have to work on that solution on a new machine, but I have some problems: 1) when building the solution I get error: "The ADO.NET provider with invariant name…
Ariela
  • 728
  • 2
  • 6
  • 23
8
votes
1 answer

MySql.ConnectorNET.Data vs MySql.Data

What is the difference between the MySql.ConnectorNET.Data and the MySql.Data packages on NuGet? They both appear to be published by the same user (MySQL), and the Project Site links point to the same location…
ken
  • 16,047
  • 3
  • 46
  • 70
7
votes
4 answers

How to insert a very large number of records into a MySql database as fast as possible

I have a database table like below: create table temperature (id int unsigned not null auto_increment primary key, temperature double ); And in my program I got about 20 million temperature to insert into the table. I worke in .Net environment, use…
Hancy
  • 453
  • 2
  • 5
  • 9
5
votes
1 answer

MySql *completely random* Unable to connect to any of the specified MySQL hosts

This one is killing me. We have an ASP.NET/Mono application on a MySQL database. For months we've been plagued by a completely random but consistent occurrence of "Unable to connect to any of the specified MySQL hosts". I'm by no means a MySQL…
hikaru
  • 1,966
  • 1
  • 20
  • 27
5
votes
3 answers

Authentication method 'mysql_old_password' not supported

Updated the mysql connector. Net to version 6.6.4 provider to integrate with visual studio 2012, but now when I try to configure the connection to the edmx occurs the error "Authentication method 'mysql_old_password' not supported".
Cristiano Nascimento
  • 51
  • 1
  • 1
  • 2
4
votes
2 answers

Set Program Name for display in MySQL Process List

Is there a way to specify the Program name for an entry in the process list? Usually, all the connections say 'None' or 'MySQLWorkbench'. There was one case where I actually saw the name of the .exe I was running in the list of connections but I…
chriszumberge
  • 794
  • 1
  • 16
  • 33
4
votes
1 answer

How do multi rows insert with MySqlCommand and prepare statement?(#C)

Mysql give example how insert rows with prepare statement and .NET: http://dev.mysql.com/doc/refman/5.5/en/connector-net-programming-prepared.html Its looks that its works like that,because in the end of each iteration call…
Ben
  • 23,101
  • 33
  • 104
  • 161
3
votes
1 answer

MySQL and LINQ to SQL via Connector/Net | C#

I need to get data from MySQL database using Connector/Net and Linq2SQL. Is it possible to do without DBlinq or smth else? Found this example - http://www.primaryobjects.com/CMS/Article100.aspx
CheatRU
  • 33
  • 1
  • 3
3
votes
1 answer

C# MySql Connector/Net issues

Currently running Mono. I loaded MySQL and installed connector/net in my gac folder located in /usr/lib/mono/gac. The problem is that everytime I try to run it using a simple connection test, I get the following error: **…
zeboidlund
  • 8,829
  • 25
  • 108
  • 176
3
votes
0 answers

MySQL Connector/NET Any() inside Where() causes NotImplementedException

I have a query that is dynamically generated for the purpose of searching a rather large set of records. I am using MySQL Connector/NET 6.8.3 via a NuGet package with Entity Framework 6. The Expression which is executed inside the Where is built…
Los Frijoles
  • 4,501
  • 3
  • 27
  • 46
3
votes
1 answer

MySQL Connector/NET Output Parameter Returning NULL

Using the following code: MySqlParameter curParam = new MySqlParameter("var", MySqlDbType.Int32); curParam.Direction = System.Data.ParameterDirection.Output; oCmd.Parameters.Add(curParam); With the following Stored Procedure: CREATE PROCEDURE…
Aaron J Spetner
  • 1,907
  • 1
  • 16
  • 28
2
votes
2 answers

MySQL GRANT to User@'host' not behaving as expected

EDIT: I reinstalled MySQL and this fixed itself. No idea what the issue was. I ran the following commands in MySQL from the command line: 1. REVOKE ALL PRIVILEGES ON MyDB.* FROM user@'%'; 2. DROP USER user@'%"; 3. GRANT INSERT,SELECT,DELETE,UPDATE…
Ignacio
  • 4,400
  • 1
  • 13
  • 10
2
votes
2 answers

Error while using BulkCopy (Failed to read the result set)

I developed a vb.net application that fills tables with API requests from another server and transfers those tables to MySql database using MySqlBulkCopy. Here is the helper class(initialized only once) that I use to bulk copy multiple tables.…
thearctoss
  • 21
  • 4
2
votes
2 answers

NullReferenceException when trying to connect to MySQL with Windows authentication

I'm trying to connect to a local MySQL database using Windows authentication (integrated security). I use the following connection string: server=localhost;database=mydatabase;integratedsecurity=True On MySqlConnection.Open() I get a…
Robert Hegner
  • 8,196
  • 6
  • 51
  • 89
2
votes
1 answer

MySQL Connector 6.7.4 Entity Framework 5 Model First

I am using Visual Studion 2012, MySQL 5.6.14, Connector for .NET 6.7.4 and Visual Studio plug-in 1.0.2 I have created an Entity Framework but cannot get "Generate Database from Model" to work. I have tried the modification suggested…
Revin Kevin
  • 53
  • 8
1
2 3