Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Thu Oct 18, 2018 4:39 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: How can I connect MySQL Database from other computer?
PostPosted: Sun Mar 10, 2013 5:13 am 
Offline

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
 Profile  
Reply with quote  
 Post subject: Re: How can I connect MySQL Database from other computer?
PostPosted: Sun Mar 10, 2013 5:31 am 
Offline
User avatar

Joined: Fri Oct 28, 2005 7:05 am
Posts: 565
Location: Emsworth, UK
In RS, the same way you connect locally but use the hostname or IP address of the remote mySQL server, instead of localhost or 127.0.0.1.

At the server end. The server may need to be configured to listen for remote connections and to allow connection from remote IP addresses. Where the remote server is behind a firewall, the firewall must be configured to allow connections to the mySQL TCP port (3306 default).

More details here. The instructions are for Linux but the principles apply to all platforms.
http://www.cyberciti.biz/tips/how-do-i- ... erver.html

_________________
Yes it's me in the avatar


Top
 Profile  
Reply with quote  
 Post subject: Re: How can I connect MySQL Database from other computer?
PostPosted: Sun Mar 10, 2013 5:59 am 
Offline

Joined: Sat Oct 22, 2011 11:30 pm
Posts: 4
Thanks a lot.

Please, if possible can you guide me step by step from MySQL to RS Form?

Thanks once again.


Top
 Profile  
Reply with quote  
 Post subject: Re: How can I connect MySQL Database from other computer?
PostPosted: Sun Mar 10, 2013 7:21 am 
Offline

Joined: Sat Dec 24, 2011 5:32 am
Posts: 40
Location: Germany
Hello,
you should be able to connect to a remote mySQL database after reading this description:

http://docs.realsoftware.com/index.php/MySQLCommunityServer

Greetings,
Christian


Top
 Profile  
Reply with quote  
 Post subject: Re: How can I connect MySQL Database from other computer?
PostPosted: Sun Mar 10, 2013 7:37 am 
Offline

Joined: Sat Oct 22, 2011 11:30 pm
Posts: 4
Great help.

Thankyou Christian.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group