# mysqlcommunityserver error **URL:** \ **Category:** Databases\ **Created:** [February 17, 2014, 5:05pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400 "2014-02-17T17:05:11Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 5:05pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/1 "2014-02-17T17:05:11Z")
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 ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [February 17, 2014, 5:15pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/2 "2014-02-17T17:15:30Z")
you have to place the plugin in the dir & restart the IDE ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 5:52pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/3 "2014-02-17T17:52:30Z")
Hi there. You mean in my directory C:\Program Files\Xojo\Xojo 2013r4.1 Regards ---
**Author:** ![Tomas\_J](https://forum.xojo.com/user_avatar/forum.xojo.com/tomas_j/32/311_2.png) [@Tomas\_J](https://forum.xojo.com/u/Tomas_J)\ **Post date:** [February 17, 2014, 5:56pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/4 "2014-02-17T17:56:38Z")
negative the /plugins folder ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 6:00pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/5 "2014-02-17T18:00:38Z")
That is where I put it Tomas: C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\MSSQLServerPlugin.xojo\_plugin ---
**Author:** ![Tomas\_J](https://forum.xojo.com/user_avatar/forum.xojo.com/tomas_j/32/311_2.png) [@Tomas\_J](https://forum.xojo.com/u/Tomas_J)\ **Post date:** [February 17, 2014, 6:08pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/6 "2014-02-17T18:08:38Z")
check this out… ```auto 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 ``` ---
**Author:** ![Wayne\_Golding](https://forum.xojo.com/user_avatar/forum.xojo.com/wayne_golding/32/165_2.png) [@Wayne\_Golding](https://forum.xojo.com/u/Wayne_Golding)\ **Post date:** [February 17, 2014, 6:22pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/7 "2014-02-17T18:22:50Z")
> [@65883:@Michael Cebasek](#): > > C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\MSSQLServerPlugin.xojo\_plugin 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. ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [February 17, 2014, 6:25pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/8 "2014-02-17T18:25:22Z")
[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 ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 6:25pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/9 "2014-02-17T18:25:30Z")
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 ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 6:31pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/10 "2014-02-17T18:31:33Z")
Hi Guys. Tomas’ code gives me the same message… I’m confused… Regards ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [February 17, 2014, 6:34pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/11 "2014-02-17T18:34:57Z")
You quit the IDE and restarted it ? Post a listing of C:\Program Files\Xojo\Xojo 2013r4.1\Plugins\ ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 6:56pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/12 "2014-02-17T18:56:08Z")
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 ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [February 17, 2014, 7:06pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/13 "2014-02-17T19:06:13Z")
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 ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 7:08pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/14 "2014-02-17T19:08:22Z")
Hi Mr. Palardy. I get the same error “no class PostgreSQLDatabase” ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 7:14pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/15 "2014-02-17T19:14:28Z")
Just so you know I have verified that the databases exists and I can access it via command line. FYI. Regards ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [February 17, 2014, 7:31pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/16 "2014-02-17T19:31:34Z")
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](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 ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 17, 2014, 9:15pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/17 "2014-02-17T21:15:17Z")
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 ---
**Author:** ![Norman\_P](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/858c86/32.png) [@Norman\_P](https://forum.xojo.com/u/Norman_P)\ **Post date:** [February 17, 2014, 9:25pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/18 "2014-02-17T21:25:08Z")
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 ---
**Author:** ![Michael\_Cebasek](https://forum.xojo.com/letter_avatar_proxy/v4/letter/m/3d9bf3/32.png) [@Michael\_Cebasek](https://forum.xojo.com/u/Michael_Cebasek)\ **Post date:** [February 18, 2014, 1:10pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/19 "2014-02-18T13:10:16Z")
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 ---
**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\ **Post date:** [October 29, 2020, 5:05pm UTC](https://forum.xojo.com/t/mysqlcommunityserver-error/14400/20 "2020-10-29T17:05:05Z")