Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP and Mysql
Message
 
À
11/07/2005 18:11:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Divers
Thread ID:
01031422
Message ID:
01031519
Vues:
17
This message has been marked as the solution to the initial question of the thread.
Hi Antonio,

>Is it possible to insert records on mysql table (Linux)?

You need to download the latest MySQL ODBC drivers from http://dev.mysql.com/downloads/connector/odbc/3.51.html. After installing the driver, creating a connection is pretty straight forward. You need the server name, database name, a user name and a password. If the server is installed on a non-standard port, you also need the port number.

When using a connection string, the code would look like this:
lnHandle = SQLSTRINGCONNECT( ;
	"DRIVER={MySQL ODBC 3.51 Driver};DATABASE=...;PWD=...SERVER=...;UID=..." ;
)
SQLTABLES( m.lnHandle, "Table", "curList" )
BROWSE
SQLDISCONNECT(m.lnHandle)
MySQL is sensitive to the formatting of the connection string. All identifiers should be in upper case with no additional blank between them.
--
Christof
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform