New topic: Unable to connect to MySQL server/database in project contro
<http://forums.realsoftware.com/viewtopic.php?t=45776> Page 1 of 1 [ 3 posts ] Previous topic | Next topic Author Message terreywe Post subject: Unable to connect to MySQL server/database in project controPosted: Wed Oct 31, 2012 11:38 pm Joined: Wed Oct 31, 2012 11:21 pm Posts: 1 Hi guys, Im just starting to use realstudio 2012 1.1(trail) for my assignment. so im rather new to this, heck im new even for database creation altogether.. I've created a database in MySQL server 5.5, and added data/tables with the help of NaviCat. All that is OK, and NaviCat is able to connect the the database. Now I would like to use realstudio to created the forms/reports etc. The issue now, in Real Studio Project control area, I've tried adding the database by selecting " Add To project >> Database >> Select MySql Community Server" and placed the right details, all i get is Could not connect to database....i've tried everything but still fails Im running Windows 7 Home Prem, and installed the MySQL server locally on my machine, using port 3306 which i think is the default port i guess. Appreciate any help that can be given, as im stuck with this, and the assignment is due this monday Thanks Top Bimal Post subject: Re: Unable to connect to MySQL server/database in project coPosted: Thu Nov 01, 2012 12:21 am Joined: Mon Jan 16, 2012 8:08 am Posts: 139 Location: India Hi, I am also new on this area. I think no need of adding the MysqlSevercommunity in Real Studio Project control area. U can directly connect to the database. U may get some idea from http://docs.realsoftware.com/index.php/MySQLCommunityServer Top amitavak Post subject: Re: Unable to connect to MySQL server/database in project coPosted: Thu Nov 01, 2012 1:34 am Joined: Mon Jan 02, 2012 1:51 am Posts: 332 Location: India You may put this code in a button "Action" event and check you can connect to the database. Dim db As new MySQLCommunityServer db.Host = "localhost" //db.Port = //mysql server port no, In my System, I did not set it. db.UserName = "root" db.Password = "" //put your password here db.DatabaseName = "demodatabase" If db.Connect Then MsgBox "Connected." db.Close Else MsgBox "Could not connect to the database." End If _________________ Amitava Karan Real Studio 2012 Release 1 Windows 7 (32 bit) Mac OS X Version 10.7 Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 3 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]
