I seem to be getting this error when I try to use mysqlcommunityserver on Xojo
“there is no class with this name …dim db as new mysqlcommunity server”
I have verified that I have the plugin in the folder with the plugins : C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\MSSQLServerPlugin.xojo_plugin
I have even put the old plugin from my realstudio version in … to no avail.
Do I have to do something else to get it to not calf on this simple code?
[code]dim db as new MySQLCommunityServer
dim rs as recordset
dim username as string = “fred”
dim password as string = “flintstone”
dim port as integer = 3306
dim host as string = “127.0.0.1”
dim thedatabase as string = "smurf
dim db as Database
dim rs as RecordSet
dim dbMySQL as new MySQLCommunityServer
dbMySQL.host = "YourHost"
dbMySQL.port = 3306
dbMySQL.databaseName = "YourDB"
dbMySQL.userName = "user"
dbMySQL.Password = "Password"
db = dbMySQL
If db.Connect then
rs = db.SQLSelect("SELECT * FROM YourTable")
else
rs = nil
end if
I hope you mean C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\MySQLCommunityPlugin.xojo_plugin. I don’t think you need the Microsoft SQL Server plugin for mySQL.
I have in the directory, C:\Program Files\Xojo\Xojo 2013r4.1\Plugins
I have these plugins: MSSQLServerPlugin.xojo_plugin
MySQLCommunityPlugin.rbx
MySQLCommunityPlugin.xojo_plugin
ODBCPlugin.xojo_plugin
OraclePlugin.xojo_plugin
PostgreSQLPlugin.xojo_plugin
I took out the MySQLCommunityPlugin.rbx restarted the IDE, just to be on the safe side (as I had put that in there while trying to figure out that problem.