Pulling out my hair now!

Okay this is my first mySql database. I have no problems with access and my asp pages written in vbscript. I can make connections to my mysql database with programs like workbench. I can create tables, add data... but what I am pulling out my hair on is that I can't create a connection from my own asp pages. always the same error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/test.asp, line 19

Here's line 16-19's code:
16 ConnString = "Driver={MySQL ODBC 5.1 Driver};Server=mysql501.discountasp.net;Port=3306;Database=MYSQL5_802243_***;User=djgoodys; Password=****;Option=3;
17 Set oConn = CreateObject("ADODB.Connection")
18 Set oRS =CreateObject("ADODB.Recordset")
19 oConn.Open ConnString
I have tried every connection string I can get from connectionsstrings.com.
Also and very important I cannot Use GRANT Querys in mysql workbench. No permisions it says I also can't use workbench's server addministration it won't let me in.
What is this newbie doing wrong?
I asked discountasp.net if I needed any other addon's like SSL, but they replied that I have everything I need. It seems to be a security problem with my mysql database. I have been at this for two weeks. Please help why I still have some hair left

 

Your connection string doesn't seem to follow the correct format:

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

I looked up your account and you should be able to find your connection string in the Mysql manager page of the control panel:

https://my.discountasp.net/mysql5-manager.aspx

You may also want to take a look at this page as it may give you a better idea of how to set up your connection string.

 

I can only use that connection string in mysql workbench to do querys and build tables I can't use it as a server side admin tool to set permisions on database. When I try to use the server administration tool in mysql workbench I get this error:
Error starting workbench administrator
Run time error: Could not initialize the WMI interface:
workbench.wmiOpenSession(): could not connect to target machine.
RPC Server is unavailable.

I can't use GRANT type querys It gives an error 1044 access denied for myuid@% . When I try to use it in vbscript inside an asp web file it gives me the same error as outlined in my first thread of this post. Connectionstrings.com is a great web site for this but I tried 10 different con strings from them for odbc. None of them worked.
Thank you to the discount.asp team for trying to help as Mysql is not supported and I do appreciate the help anyway.

 

Dasp upgrades to mysql 5.1!

Kudos to DASP team for upgrading all of there mysql servers to 5.1. They realy do a great job of keeping up what their users are doing and respond quickly. No wonder ive been using there servers for over 15 years!

 

Cool ;-)

 

That's a long time!