Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 640
  • Last Modified:

VB.net Connect to MySQL

Hi

Can you connect to a MySQL database using System.Data.SqlClient or and Oledb
0
Murray Brown
Asked:
Murray Brown
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Can you connect to a MySQL database using System.Data.SqlClient
no


Can you connect to a MySQL database using System.Data.Oledb
yes, using a third-party OLEDB provider:
http://cherrycitysoftware.com/ccs/providers/ProvMySQL.aspx


Can you connect to a MySQL database using System.Data.odbc
yes, using this odbc connector:
http://dev.mysql.com/downloads/connector/odbc/


but there is more: a .net connector for MySQL:
http://dev.mysql.com/downloads/connector/net/


connection strings for MySQL:
http://www.connectionstrings.com/mysql/
0
 
Daniel WilsonCommented:
Um, probably with the OleDB driver, but you'll do better to use the MySQL Connector for .Net from http://www.mysql.com/products/connector/
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much for the help
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now