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