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.