Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and Mysql
Message
 
To
11/07/2005 18:11:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Miscellaneous
Thread ID:
01031422
Message ID:
01031519
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform