Provider error '8000ffff'

[e.rigoli]

Hi to you all, I'm quite new in using mySQL, and I get a strange error message. I've moved my websites to a new server, and exported old mySQL db in .sql format.

After importing SQL everything seemed correct, and infact some websites (PHP/mySQL) perfectly work, only one (ASP/mySQL) doesn't and returns error:

Provider error '8000ffff'

Connection string is:

mySTRING = "DRIVER={MySQL ODBC 3.51 Driver};" & "SERVER=localhost;" & "DATABASE=mydb;" & "Uid=root;" & "Pwd=mypassword"

Error is at following line:

AreaBancaDati.ActiveConnection = mySTRING;

Sometimes I get also "too many connections" error or Catastrophic error.

I've just tried to reinstall mySQL and also updated MDAC, but nothing happened. So silly that same code that worked on previous server and now returns errors!!

Any idea/suggestion? Thanks in advance!