| View previous topic :: View next topic |
| Author |
Message |
Eis
Newbie
Joined: 07 Jul 2008
Posts: 1
|
 Posted: Mon Jul 07, 2008 6:28 am Post subject: Multiple Databases into One |
 |
|
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 |
|
 |
r4zoli
Super User
Joined: 17 May 2005
Posts: 570
Location: Budapest, Hungary
|
| Posted: Tue Jul 08, 2008 7:13 am Post subject: |
|
|
| OOo Base can connect only one datasource. Multi connection on the required enhanchement list, more than three years, see issue 42464. |
|
| Back to top |
|
|
QuazzieEvil
Super User
Joined: 17 Jan 2007
Posts: 599
Location: Houston, TX
|
| Posted: Tue Jul 08, 2008 8:01 am Post subject: |
|
|
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 |
|
|
|
