Tuesday, December 18. 2007Using OpenOffice Base 2.3.1 with PostgreSQLPrinter FriendlyRecommended Books: Getting Started with OpenOffice.org 3 written by OO.org group Database Programming with OO Base
Comments
Display comments as
(Linear | Threaded)
What about the ODBC driver, which is probably the most familiar to windows users?
#1
on
2007-12-21 12:16
We didn't include ODBC because from what we have read compared to the jdbc and sdbc drivers it is not as capable as far as Open Office is concerned. On top of that it only works on windows.
In another article we will demonstrate using MS Access (doing linked tables and pass thru queries with PostgreSQL). In that article we will cover using the ODBC driver.
#2
on
2007-12-23 20:28
I struggled for a few hours to connect OpenOffice to a PostgreSQL database as the documentation is really scarce. I found your step by step tutorial excellent. Thank you!
#3
on
2008-01-19 07:18
I just started to use OO Base with PostgreSQL. I works very nice, but I have problem with created queries, where the LEFT or RIGHT JOIN is used. It results into the syntax error. OO Base puts into the SQL code sth. like " { OJ " (without quotas) and it makes from my point of view SQL command unuseable. Is there any way how to use LEFT or RIGHT JOINs in this combination OO Base + PostgreSQL ?
Thank you for any advice.
#4
on
2008-02-05 09:50
As mentioned above - uncheck the Use Outer Join syntax in the Advanced settings tab and that should fix it.
#5
on
2008-02-12 09:36
We are having a performance problem with our database. The problem
exists when we include a constraint in GCTBALLOT.
What sort of error do you get?
#7
on
2008-03-24 23:22
Thanks Leo Hsu and Regina Obe for the excellent article. The steps were very clear. I agree with Cosmin also. Documentation for postgresql connection from Open Office Base is very scarce especially for JDBC driver. Once again thanks for the article.
#8
on
2008-04-10 07:04
I have a serious problem using jdbc. It ignores the aliases from my queries.
Using ODBC changes varchar to varbinary? And in both cases subforms do not link to father form, meaning that I get all results in the subform, not just restricted to father... Strange behaviour that makes all this unusable to me...
#9
on
2008-06-16 06:32
We connected to Postgres easily enough. Our problem is when generating reports in openoffice. The reports took at least 10 minutes if not longer to generate. When running the query in the query view it was quick and took seconds. But for some reason it took forever to generate the reports, and they don't seem that complicated to me. And our recordset is only about 4,000 records. So it's not a huge recordset we are trying to generate reports with. Is this a problem with openoffice connecting to Postgres or something with Postgres? Or am I doing something else wrong? Any help would be appreciated.
#10
on
2008-07-07 11:25
Hi, I am new to OoBase 2.4. Now I am trying to create a database. I am having some problem with creating a search key using my own words and not using primary key. Please help me.
Thanks in advance.
#11
on
2008-09-26 23:52
I cant edit tables without primary key using the oobase. please help me
I think that is true of most products that connect to relational databases. How would it know which record to update without a primary key.
The only way you can update records without a primary key is with an SQL update statement, but then you run the risk of updating multiple records. Is there a reason you don't have primary keys?
#13
on
2008-10-07 08:59
Many thanks for your tutorial guys. I managed to install and configure the PostgreSQL JDBC Driver on OOo 3.0.1. I haven't been able to find any comparable documentation for the MySQL JDBC.
Good work!
#14
on
2009-05-18 00:19
Hi,
This Journal has well define and illustrative information about Database setup steps. I was come across your this post while I search for JDBC Driver download websites, but it has hacked me for a while. Thank you for the post |
Entry's LinksQuicksearchCalendar
Categories
Blog Administration |
In our Product Showcase section of this issue, we introduced Fusion Charts which is a flash-based charting product that makes beautiful flash charts. It comes in both a free and a non-free more bells and whistles version. In this 3-part series arti
Tracked: Dec 16, 14:26
Tracked: Jun 28, 02:10
Tracked: Feb 17, 18:07