OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Accessing remote database

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
bcwhittle
Newbie
Newbie


Joined: 14 Oct 2006
Posts: 2

PostPosted: Sat Oct 14, 2006 4:05 pm    Post subject: Accessing remote database Reply with quote

I am just beginning to look at OOo to handle some interesting situations. First on my list is having a database of members of my organization on our webserver, accessable by any of the Board of Directors from their own computers. Is this possible? I can set up a MYSQL database on my server, but is there a way to access it in OOo, then save back to the server? Or am I forced to download then upload when done via FTP?

Thanks,
Brian
Back to top
View user's profile Send private message
audionuma
OOo Enthusiast
OOo Enthusiast


Joined: 23 Feb 2006
Posts: 126
Location: France

PostPosted: Sat Oct 14, 2006 9:24 pm    Post subject: Reply with quote

hello,
you can use OOo as a frontend (or client) to a MySql database.
All the data remains on the server.
_________________
OOo 2.3 / Mac OS PPC X.4.11
Back to top
View user's profile Send private message
bcwhittle
Newbie
Newbie


Joined: 14 Oct 2006
Posts: 2

PostPosted: Sun Oct 15, 2006 5:41 am    Post subject: Reply with quote

I'm glad to hear that! Now . . . how do I point OOo to the database on my server? Whenever I open Base, I do not have anything "registered" to browse. Is there a tutorial or guide covering this aspect?

Thanks,
Brian
Back to top
View user's profile Send private message
robert_pdx
Newbie
Newbie


Joined: 14 Oct 2006
Posts: 2

PostPosted: Sun Oct 15, 2006 6:50 am    Post subject: Reply with quote

You can set up an ODBC connection. Search for and download the mySQL ODBC driver for your platform. In Windows XP, following the driver install, it's configured in Control Panel | Administrative Tools | Data Sources (ODBC). Input your server location, username and password for connection to the mySQL database, etc.

This traffic is not secure, so your username/password is transferred in clear text. To avoid this, you could connect to your network with a VPN, or if you have ssh running as a service on the network, use Putty to create a tunnel, so the ODBC connection is pointed to localhost, and Putty forwards this traffic to the remote host through your ssh connection.

Once you have your connection running, then open Base and create a new database, connect to existing database, and there you will see the resource you created in the ODBC setup.

Missing detail here of course, but this should get you started. Start Googling.
Here's a page on using ssh for a secure tunnel:
http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group