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]
