Thanks for your post and i made the changes you suggested but it shows the next message error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[MySQL][ODBC 3.51 Driver][mysqld-3.23.49-max]You have an error in your SQL syntax near '(int,codmodulo) from modasg where cod='123'' at line 1
/callc/Ing_modulos.asp, line 22


this is my code at line 22:

sqlcodmod="select convert(int,codmodulo) from modasg where cod='"&request("cod")&"'" 
   set rscodmod=conn.execute(sqlcodmod)

Am i doing smothing wrong?
Thanks for your help.