Ozeki NG MySQL Connectivity Parameters Rumi, July 5, 2012July 5, 2012 Databse connection =========================== Driver={mySQL ODBC 5.1 Driver};Server=192.168.0.100;Port=3306;Option=4;Database=mydb;Uid=userdb;Pwd=putmypwd; Sending-Polling ============ SELECT id,sender,receiver,msg,msgtype,operator FROM ozekimessageout WHERE status=’send’ Sending-sending ============= UPDATE ozekimessageout SET status=’sending’ WHERE id=’$id’ Sending-Sent ============== UPDATE ozekimessageout SET status=’sent’, senttime=’$senttime’ WHERE id=’$id’ Sending-Not sent =========== UPDATE ozekimessageout SET status=’notsent’ WHERE id=’$id’ SQL for receiving ============== INSERT INTO ozekimessagein (sender, receiver, msg, senttime, receivedtime, msgtype, operator) VALUES (‘$originator’,’$recipient’,’$messagedata’,’$senttime’,’$receivedtime’,’$messagetype’,’$operatornames’) Administrations Configurations (Windows) Ozeki