Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
This causes VFP8 and VFP9 to crash with a Fatal Execption Error.
lcdsnless =;
"DRIVER={MySQL ODBC 3.51 Driver};" +;
"SERVER=" + '192.168.1.100' + ";" +;
"UID=" + 'rileys' + ";" +;
"PASSWORD=" + 'bingo'+ ";" +;
"DB=" + 'test' + ";" +;
"PORT=3306;" +;
"SOCKET=;" +;
"OPTION=" + TRANSFORM(1+4+8+64+512+1024+2048+16384+524288) + ";" +;
"STMT;"
wait lcdsnless window
gn=SQLSTRINGCONNECT(lcDSNLess)
IF gn > 0
WAIT 'OK!'
cancel
? SQLTABLES(lnHandle,"TABLES")
browse last nocaptions
SQLDISCONNECT(lnHandle)
ELSE
=AERROR(laError)
MESSAGEBOX("Error at Connecting"+CHR(13)+;
"Description:"+laError[2])
ENDIF
The wait executes to confirm my settings and then when sqlstringconnect executes VFP halts.
I tried using gn=sqlconnect('mysql','rileys','bingo') and I get "Could not determine the driver so could not lookup the setup library" in the odbc error string.
When I test the connection using the ODBC admin in XP it tests fine and I can connect to the database using mysql browser so I think my connection to the server and database is not the issue.
Précédent
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