Difference between phpmyadmin and recordser

[muzio]

I've a problem with a connection between ASP and MySQL.
If I use phpmyadmin to do a query, the db response with some results, if I use a recordset to do the same query, I have no results.
But, if I remove the conditions the results are the same.

I post the code that I use:


conn_STRING = "server=127.0.0.1;db=name_db;uid=user;pwd=pass;driver=MySQL ODBC 3.51 Driver"

set prod = Server.CreateObject("ADODB.Recordset")
prod.ActiveConnection = conn_STRING
prod.Source = "SELECT * FROM prodotti WHERE ID_SOTTOCATEGORIA=5 ORDER BY NUMERO"
prod.CursorType = 0
prod.CursorLocation = 2
prod.LockType = 3
prod.Open()
While NOT prod.EOF
Response.write prod("NOME") & "<br>"
prod.MoveNext
Wend
prod.Close
Set prod = Nothing



Sorry for my english.
Thanks

Matteo