I have no experience with MySql, so I have a question: SqlSetEnv is the stored procedure or separate application?
>Hi:
>
>Using VFP 8.0 to query MySQL through ODBC with myodbc verion 2.50 works fine
>but using version 3.51 returns currency fields instead of numeric/decimal
>fields
>
>I know you need to set the version to SQL_OV_ODBC2 using SqlSetEnv
>But I haven't a clue on how to do it or when to do it - before
>making,during,or after making connection
>
>Can something be put in options of ODBC or SQL command on Connect
>
>Visual Foxpro does not have a command called SQLSetEnvAttr
>
>Only command I know to send query to server is Sqlexec()
>
>My connection setting are
>ODBCString=DRIVER={MySQL ODBC 3.51
>Driver};SERVER=Localhost;UID=?;PWD=?;DATABASE=maps;option=3
>
>Any help would be appricated,
>
>Alberto