New topic: How can I connect MySQL Database from other computer?
<http://forums.realsoftware.com/viewtopic.php?t=47241> Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message ctcenter Post subject: How can I connect MySQL Database from other computer?Posted: Sun Mar 10, 2013 5:08 am Joined: Sat Oct 22, 2011 11:30 pm Posts: 4 Dear All; I am very new to RS. I have been using Visual Foxpro till today. Can anybody help me to connect MySQL Database residing on another computer? Regards. Top JohnV Post subject: Re: How can I connect MySQL Database from other computer?Posted: Sun Mar 10, 2013 4:03 pm Joined: Sun Jan 28, 2007 2:38 pm Posts: 192 1. Set up a new Property "MyDatabase' in the App Class (if desktop app) or session class (if web app) Then call something like: MyDatabase = New MySQLCommunityServer MyDatabase.Host = "127.0.0.1" //Wherever.... MyDatabase.Port = 3306 //or whatever port it on MyDatabase.DatabaseName = "Your_Database_name" MyDatabase.UserName = "Your_UserName" MyDatabase.Password = "Your_{password" MyDatabase.MultiThreaded=false // There is a bug in the mysql plugin it is not thread safe so set it to false until the finish the plugin fix. If MyDatabase.Connect Then //You are good to go Else //Handle Error End If Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 2 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
