MySQLCommunityServer
From Real Software Documentation
Used to open MySQL Community Edition databases.
| Properties | ||||||||||||
|
| Methods | |||||||||||||||
|
Notes
In order to use this class, you must install the MySQLCommunityPlugin database plug-in in your plugins folder. This class connects to the MySQL Community Edition server. It is the open-source version of MySQL that is freely available. Please refer to the Which Edition page which clarifies the differences between the Community and Enterprise editions of MySQL.
If the plug-in is installed, you can also open a MySQL Community Server database in the IDE using the Project ↠ Add ↠ Database ↠ Select MySQL Community Server command. This command presents a dialog box that requests the server, port, database, Username, and Password properties.
The MySQLPlug-in is at the Real Software web site, http://www.realsoftware.com.
There may be patches that you need to install for Linux. MySQL compiles the libraries using the intel compiler and this sometimes requires additional support libraries from mySQL. They are available at http://dev.mysql.com/downloads/os-linux.html
The MySQLCommunityServer engine supports only the MoveNext RecordSet navigation method.
Examples
This example establishes a connection to a remote database.
db = New MySQLCommunityServer
db.Host = "192.168.1.172"
db.Port = 3306
db.DatabaseName = "MyOwnMySQLDatabase"
db.UserName = "Mary"
db.Password = "Elton"
If db.Connect Then
//proceed with database operations
Else
MsgBox("Connection failed!")
End If
See Also
Database Class, PreparedSQLStatement, PostgreSQLDatabase, MSSQLServerDatabase, MySQLPreparedStatement, RecordSet classes
