mysqlcommunityserver error

Hi Everyone.

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

db.Host=host
db.port=port
db.UserName=username
db.Password=password

db.DatabaseName = thedatabase[/code]

and yes I am aware I have done Nothing with the code to this point!.. (smile)

Regards

you have to place the plugin in the dir & restart the IDE

Hi there.

You mean in my directory

C:\Program Files\Xojo\Xojo 2013r4.1

Regards

negative the /plugins folder

That is where I put it Tomas:

C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\MSSQLServerPlugin.xojo_plugin

check this out…

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.

[quote=65883:@Michael Cebasek]That is where I put it Tomas:

C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\MSSQLServerPlugin.xojo_plugin[/quote]

Thats the MS SQL Server plugin
Not the MySQL one

Hi Wayne.

That is the one I mean. It was there from the beginning i.e. when I installed it on my Windows Machine.

I’m going to try Tomas’ code and see if that runs.

Will advise.

Regards

Hi Guys.

Tomas’ code gives me the same message…

I’m confused…

Regards

You quit the IDE and restarted it ?
Post a listing of C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\

Hi Mr. Palardy.

I did shut down xojo, and restarted it.

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.

Regards

OK so try something like

dim db as Database dim rs as RecordSet dim dbMySQL as new PostgreSQLDatabase
just to be sure the plugins are loading

Hi Mr. Palardy.

I get the same error “no class PostgreSQLDatabase”

Just so you know I have verified that the databases exists and I can access it via command line.

FYI.

Regards

What that tells me is that either

  1. the plugins are not loading for some reason
  2. the version you’re launching is not the one where you have the plugins

But I can’t tell which
Grab DebugView from MS and install it http://technet.microsoft.com/en-ca/sysinternals/bb896647.aspx
Run it
Quit the IDE
Then start the IDE
See what messages are logged in DebugView

Hi.

Looks to me like it is loading…

[253884] !!! Advanced types not yet implemented!!!
[253884] Loaded: RBAddressBook.xojo_plugin
[253884] Loaded: RBAppearancePak.xojo_plugin
[253884] Loaded: RBCrypto.xojo_plugin
[253884] Loaded: RBGameInput.xojo_plugin
[253884] Loaded: RBGUIKit.xojo_plugin
[253884] Loaded: RBGZip.xojo_plugin
[253884] Loaded: RBHTMLViewer.xojo_plugin
[253884] Loaded: RBInternetEncodings.xojo_plugin
[253884] Loaded: RBOpenGLSurface.xojo_plugin
[253884] Loaded: RBQT.xojo_plugin
[253884] Loaded: RBREALSQLDatabase.xojo_plugin
[253884] Loaded: RBRegEx.xojo_plugin
[253884] Loaded: RBScript.xojo_plugin
[253884] Loaded: RBShell.xojo_plugin
[253884] Loaded: RBSQLiteDatabase.xojo_plugin
[253884] Loaded: RBSSL.xojo_plugin
[253884] Loaded: RBXML.xojo_plugin
[253884] Loading plugins…
[253884] Loaded: MSSQLServerPlugin.xojo_plugin
[253884] Loaded: MySQLCommunityPlugin.rbx
[253884] Loaded: MySQLCommunityPlugin.xojo_plugin

[253884] Loaded: ODBCPlugin.xojo_plugin
[253884] Loaded: OraclePlugin.xojo_plugin
[253884] Loaded: PostgreSQLPlugin.xojo_plugin

Regards

There’s at least one problem

[253884] Loaded: MySQLCommunityPlugin.rbx
[253884] Loaded: MySQLCommunityPlugin.xojo_plugin

You have 2
Keep the second one & remove the RBX one

Hi Mr. Palardy.

I did as you suggested, and now it seems to be happy.
(I initially did not have it in the plug in’s folder when the issue first started…)

However, my windows (winDOZE) machine did blue screen this morning.

Now it runs, sees my database, and when I do a record count see the correct number.

Thanks for the help.

Regards