Maybe this is a dumb question, but I don't know the answer. If I use MySQL Connector/Net, when I send SQL via ADO.NET, does my inline SQL get translated into code first and then sent to the database, or does it get sent as SQL text, and then the database engine has to translate it into code? Or doesn't ADO.NET do a translation? Or, if...
I am using the latest development version of the connector - 6.3.3 beta to connect to a mysql database via the Entity Framework 4 in VS2010. I have the following Linq statement which uses a TIMESTAMP column - createdDate - in the query. Here is the code: int timeThreshold = 5; DateTimeOffset cutoffTime = DateTime.Now.A...
I am in the process of moving from Visual Studio to Mono. I have a query which dumps about 190000 rows of a select statement into a a text file which I process from c#. Normally the whole thing goes well and is done in less than 7 seconds. On mono however, it gets to the ExecuteNonQuery, and the OUTFILE is created successfully of exac...
Hi, I am a beginer with visual studio 2008 (C#), mysql and NHibernate. I have problems with mysql connector as I don't know how to add reference to it. In my project I have: /lib/mysql-connector-net-6.1.4-src/ (downloaded from http://dev.mysql.com/downloads/mirror.php?id=387799#mirrors) Now I right click on my project -> addReferenc...
Hey, I'm working with third party user data that may or may not fit into our database. The data needs to be truncated if it is too long. We are using IBatis with Connector/J. If the data is too long a SQL exception is thrown. I have had two choices: either truncate the strings in Java or truncate the strings in sql using substring. I...
I am trying to connect to a database using MySQL C++ Connector. I have used this code segment many times: driver = get_driver_instance(); connection = driver->connect("tcp://127.0.0.1:3306", "user", "pass"); and it has worked successfully, but now I am getting this error thrown from this code segment: "Unknown MySQL server host 'ÇD$Œ...
Hello Everyone, I am using MySql Connector 6.2.3 with Visual Studio 2008 and i have a database with 119 tables, which is constantly growing. When i want to update the entity framework model "Update Model from Database" option from visual studio it is taking more than 40 mins to update, that is killing my productivity. Is this happening...
I have the following stored procedure: CREATE PROCEDURE GetSequenceNextValue(IN sequenceName VarChar(100)) BEGIN UPDATE Sequences Set currentValue = LAST_INSERT_ID(CurrentValue + 1) WHERE name = sequenceName SELECT LAST_INSERT_ID(); END But when I update my model, this procedure is not imported even into storage model. ...
Hey guys, I'm migrating from Java to C# now that I've realized I prefer the C# language features over the ones in Java, but I have this small issue. In MySQL Connector/J and JDBC, I believe that one of my applications allowed multiple PreparedStatements to be executed while another one is open, like I could perform a query that returns a...
I am using MySqlConnector/Net 5.2.7 in one of my applications written in C# for .NET 2.0. This application is deployed across different sites in the corporate network. This week, this application refused to connect to the database from a remote site suddenly. Actually, the MySqlConnection.Open() method does not return and waits indefini...
I'm trying to use the MySQL Connector/Net to connect a c# program to a MySQL Server. Problem is, the MySQL server is version 4.x, and the connector throws this exception: Connector/Net no longer supports server versions prior to 5.0 Is there a way to connect to this older MySQL Server? ...
I have MySqlMembershipProvider working with Asp.Net MVC. My question is how can I configure the table prefix... so instead of 'my_aspnet_' prefix on the tables, I want this to be either none or defined by me. My web.config: <?xml version="1.0"?> <add name="ApplicationServices" connectionString="server=localhost;user id=root;P...
Hey, I've been trying to get the MySQL connector working I've installed both the connector and the mysql client library but I am still getting this error: obj/Database.obj: In function `Database::connect()': /home/xeross/alpine/src/server/Database.cpp:13: undefined reference to `get_driver_instance' collect2: ld returned 1 exit status ...
From what I understand, MySQL 5.1 supports server-side prepared statements. Therefore the following code should prepare the statement once, and execute it 10 times: Connection conn = ds.getConnection(); PreparedStatement stmt = conn.prepareStatement("SELECT COUNT(*) FROM users WHERE user_id=?"); for (int i=0; i<10; i++) ...
I have a very weird thing that we cannot understand or fix. The short version: Some very simple SELECT-queries in MySQL hangs the whole application/program who made the query. However, its not consistent. If I have the EXACT same MySQL version locally, with the exact same table structure and the EXACT same data, the query works fine. bu...