New topic in Databases: Problem connecting MySQLDatabase on a lan
juanll - Sun Mar 30, 2008 3:36 am <http://forums.realsoftware.com/viewtopic.php?t=19567> Hello, I dont speak english very well, well my problem is that I did a program in realBasic and with mySQL, I use mySQLDatabase to connect. In the server machine i execute the software with the follow code and it works fine: Dim db as mySQLDatabase db= New mySQLDatabase Dim mRecordSet as RecordSet dim Serv as String db.host="127.0.0.1" db.port=3306 db.databaseName="basedatos" db.userName="root" db.Password="123456" If db.Connect then mRecordSet=db.SQLSelect("SELECT * FROM linfacts WHERE CodFact =" + Str(CodFact) + " AND CodTra = " + Str(CodTra) ) ... ... end if But the problem is when i try connect it in the lan, i change db.host="127.0.0.1" for db.host="192.168.1.2" (ip of the server machine) and it doesnt work!! Can you help me?? Thanks!! -- Over 900 classes with 18000 functions in one REALbasic plug-in. The Monkeybread Software Realbasic Plugin v8.1. <http://www.monkeybreadsoftware.de/realbasic/plugins.shtml> [email protected]
