cant connect to MySQL server with VB.NET but can with PHP and MySQLAdminstrator

[charvelzeppelin]

I'm trying to add a connection under the database connections in vb.net but it always says:

Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I'm choosing Microsoft OLE DB Provider for SQL Server as the provider
and I'm trying to logon as root with a password.

Will the Provider for SQL Server work with MySQL v4.0?
The database is located on localhost.

I can access the database with MySQLAdministrator and have a few php programs that utilize the database without any problems at all. Does anyone have any suggestions? thanks.

[charvelzeppelin]

no one here uses MySQL? everyone uses SQL Server??

any advice :-(

[Negative0]

If you are using mySQL then why are you using the Microsoft OLE DB Provider for SQL Server, that is for Microsoft SQL server.

MYSQL offers an ADO.NET Connector to connect to their DBs:

http://www.mysql.com/products/connector/net/

[charvelzeppelin]

If you are using mySQL then why are you using the Microsoft OLE DB Provider for SQL Server, that is for Microsoft SQL server.

MYSQL offers an ADO.NET Connector to connect to their DBs:

http://www.mysql.com/products/connector/net/

obiviously i was using the OLE DB Provider for SQL Server because I didn't know what other one to use since there was no MySQL option on there...jeeeeez. That's all the help i needed, thanks.