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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement