I’m assuming that you have Visual Studio Professional 2008, have access to an instance of MySQL server, and have moderate to advanced development experience. This MAY work with VS2008 Web edition, but not at all sure. If you haven’t, install MySQL Connector for .NET (6.2.2.0 at the time of this write-up) Optional: install MySQL GUI … Read more
install the MySQL .NET Connector found here http://dev.mysql.com/downloads/connector/net/
I just had the same situation when trying to configure Visual Studio Professional 2017 environment with MySQL, ADO.NET (Database First) and EF6. Note: Please follow steps in the same order. Uninstall/remove “Connector/NET” and “MySQL for Visual Studio” if installed. Install “MySQL for Visual Studio” v2.0.5 CTP (MySQL for Visual Studio). Note: Install MySQL for Visual … Read more
Using the engine in place of the raw_connection() worked: import pandas as pd import mysql.connector from sqlalchemy import create_engine engine = create_engine(‘mysql+mysqlconnector://[user]:[pass]@[host]:[port]/[schema]’, echo=False) data.to_sql(name=”sample_table2″, con=engine, if_exists=”append”, index=False) Not clear on why when I tried this yesterday it gave me the earlier error.
My understanding is that you want to access a mysql server running on a remote machine and listening on let’s say port 3306 through a SSH tunnel. To create such a tunnel from port 1234 on your local machine to port 3306 on a remote machine using the command line ssh client, you would type … Read more
Change your funcursor.execute(query, uName) call to: funcursor.execute(query, (uName, )) The second argument in execute takes a list/tuple of strings, not a string. The above call creates the tuple before passing in the string to execute, so no error is thrown. The reason why execute takes a list/tuple of strings is because it does not know … Read more
Install Oracle’s MySql.Data NuGet package. using MySql.Data; using MySql.Data.MySqlClient; namespace Data { public class DBConnection { private DBConnection() { } public string Server { get; set; } public string DatabaseName { get; set; } public string UserName { get; set; } public string Password { get; set; } private MySqlConnection Connection { get; set;} private … Read more
It seems the mysql connectivity library is not included in the project. Solve the problem following one of the proposed solutions: MAVEN PROJECTS SOLUTION Add the mysql-connector dependency to the pom.xml project file: <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.39</version> </dependency> Here you are all the versions: https://mvnrepository.com/artifact/mysql/mysql-connector-java ALL PROJECTS SOLUTION Add the jar library manually to the … Read more