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

Multiple Databases into One

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


Joined: 07 Jul 2008
Posts: 1

PostPosted: Mon Jul 07, 2008 6:28 am    Post subject: Multiple Databases into One Reply with quote

Our company is in the process of getting rid of as many proprietary programs (read M$) as possible. One of Microsoft's very handy tools is Microsoft Access, so my suggestions was to switch to OO Base.
We use MS Access where we want a user to have access to data via Forms and Queries without having to write a whole app. We connect to many different database engines (MySQL, Informix, SQL Server,etc) via ODBC. Now MS Access allows you to setup connections to multiple databases in one Access database, e.g. connect to two different MySQL DB's.
How can this be done in OO Base - I have not managed to get that working.
Am I missing something?
Back to top
View user's profile Send private message
r4zoli
Super User
Super User


Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary

PostPosted: Tue Jul 08, 2008 7:13 am    Post subject: Reply with quote

OOo Base can connect only one datasource. Multi connection on the required enhanchement list, more than three years, see issue 42464.
Back to top
View user's profile Send private message
QuazzieEvil
Super User
Super User


Joined: 17 Jan 2007
Posts: 599
Location: Houston, TX

PostPosted: Tue Jul 08, 2008 8:01 am    Post subject: Reply with quote

The only possible solution, and it is not a pretty one, is to create a Base document for every back-end. Each Base doc can have the respective forms. Now, from writer you can create a main switchboard that launches the forms for each respective database.
_________________
Free Docs @ http://www.baseprogramming.com/resources.html
Book @ lulu.com http://www.lulu.com/content/2455551
Back to top
View user's profile Send private message Visit poster's website
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