Data source cannot be found (ODBC 5.2.5)

[Stijn Beeckmans]

Hi

I recently bought a new laptop which has MySQL ODBC driver 5.2.5. My website (written in ASP) worked fine on my old laptop (MySQL ODBC driver 5.1.5).

When I try to run my code on my new laptop, I get the error saying that the data source cannot be found.

So, my question is: how can I connect using MySQL ODBC 5.2.5?? I tried using a DSN connection string (DSN connection tested and working) and a DSN-less. Both produced the same error. Do I forget something?

My code:

'DSN-less
'connStr = "Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=***;User=***;Password=***;Option=3;"
'DSN
connStr = "DSN=DSNvzkdb"

set conn = server.createobject("adodb.connection")
conn.open connStr

Thanks!