Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use MySQL in VFP
Message
 
 
To
22/04/2005 12:59:15
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Novell 4.x
Database:
MySQL
Miscellaneous
Thread ID:
01007554
Message ID:
01007637
Views:
11
This message has been marked as a message which has helped to the initial question of the thread.
Conectarse ....

cServidor = "67.15.154.85"
cBasedatos = "Datos"
cUsuario = "prueba"
cPassword = "123"

cCadConn = "Driver={MySQL ODBC 3.51 Driver};Server=" + cServidor + ;
";Option=16834" + ;
";Database=" + cBasedatos + ;
";Uid=" + cUsuario + ;
";Pwd=" + cPassword

SQLSetprop(0,"DispLogin",3)

nH = Sqlstringconnect(cCadConn)
If nH > 0
=Messagebox("OK")
SQLDisconnect(nH)
Else
=Aerror(aSubError)
Messagebox("Error descripción:" + aSubError[2])
Endif

*****************************************
Also it reviews the functions: SQLExec, SQLPrepare, SQLRollback, SQLCommit
David Amador Tapia
WebMaster "La Web de Davphantom"
www.davphantom.net
Cartagena. Colombia
Previous
Reply
Map
View

Click here to load this message in the networking platform