MySQL connection

A similar issue like others had, but I did not find a solution in other discussions. I have trouble connecting from my .NET page to my MySQL database.

I get this error:
[COMException (0x80004005): [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.]

My List of SQL DSN:
Data Source NameSQL Server
DSN_needleno_Needlemy02.Winhost.com

I use Javascript connection string:
Application("app_connection_string") = "Data Source=DSN_needleno_Needle; Initial Catalog=mysql_70130_needle; port=3306; User Id=XX; Password=XX;";
var site_connectionstring = "app_connection_string";
var conn = Server.CreateObject("ADODB.Connection");
conn.Open(Application.Contents(site_connectionstring));

I have no problem logging in to the database using the MySQL Workbench:
Hostname: my02.Winhost.com
Port: 3306
Username: XX
Password: XX
Default Schema: mysql_70130_needle

Did I miss something? do I have to set up access somewhere?

Thanks a lot!

 

Thanks for the reply. How can I connect through .NET? You have sample code for that? Thanks again.