Chris, I think I understand the problem. A lot has changed for OO databases since the last stable release and the latest devlopment release. There are a lot more features in the latest development release. Download the latest development build of OO. It can be found here:
http://download.openoffice.org/680/index.html To connect to a database start Writer or Base and click File>New. Then select database as the type of file you wish to create. A wizard should open up that will guide you through the steps of connecting to an existing database. I'm guessing you'll need to hook to PostgreSQL via a JDBC driver. Hopefully they have one. See my response to Ed's post for tips on setting up OO to use the driver and make the connection. I'll get that tutorial written ASAP. I can see its needed. Landon On Mon, 31 Jan 2005 16:16:49 +0000, Chris Green <[EMAIL PROTECTED]> wrote: > On Mon, Jan 31, 2005 at 07:18:18AM -0800, Sunburned Surveyor wrote: > > On Sat, 29 Jan 2005 16:37:55 +0000, Chris Green <[EMAIL PROTECTED]> wrote: > > > How can one add a new 'external' datasource to Database? > > > > > > In Writer and Calc the View menu has a Datasource entry where one can > > > do this but the View menu isn't similarly expanded in Database. > > > > > > > I'm not sure I understand your question exactly, but I'm going to take > > a stab at a reply. First of all, with the latest development versio of > > OpenOffice, you connect to an existing database, or use the embedded > > HSQL database. AS far as I know, connections to multiple databases in > > one .odb docuement is not allowed. The trick is to get the data into > > your database using it's import functions, and then access that > > database with OpenOffice. For example, I'm using MySQL and OpenOffice. > > If I have data in 3 CSV files that I want to access in OpenOffice, I > > would use the MySQL command interface to import those CSV files into > > my MySQL database. I could then access and manipulate that data from > > an OpenOffice .odb document connected to that MySQL database. > > > My problem is that I don't see how to connect the new Database > application in OOo to an existing Postgresql database. > > I have successfully connected from Writer to the database and created > a Form which allows me to view a table from the database. To do this > one uses the View menu which has a Datasource option. (I used the new > SDBC driver for psotgres) > > I'd like to do the same from the new Database application but the > View menu doesn't have the same Datasource option. > > -- > Chris Green ([EMAIL PROTECTED]) > > "Never ascribe to malice that which can be explained by incompetence." > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
