Alexander Thurgood wrote:
Le 26/05/12 22:30, Girvin R. Herr a écrit :
Hi Girvin,
If you have links to LO/OOo configuration documentation for ODBC
connection to MySQL, I would be willing to try it.
Thanks.
I wrote a tutorial for this very purpose many years ago for OOo, but it
would
Andreas Säger wrote:
Am 26.05.2012 22:13, Girvin R. Herr wrote:
Andreas,
Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
connection type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
path and the MySQL 5.0.67 server.
Sun (Oracle) Java version
Le 26/05/12 22:30, Girvin R. Herr a écrit :
Hi Girvin,
> If you have links to LO/OOo configuration documentation for ODBC
> connection to MySQL, I would be willing to try it.
> Thanks.
I wrote a tutorial for this very purpose many years ago for OOo, but it
would equally apply to LO today, thing
security flaw in java. Some other programs almost never have security issues at all and only upgrade to add new features but with java it's just to fix whatever they broke or didn't fix last time.
Regards from
Tom :)
--- On Sat, 26/5/12, Girvin R. Herr wrote:
From: Girvin R. He
5/12, Girvin R. Herr wrote:
From: Girvin R. Herr
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Saturday, 26 May, 2012, 22:34
Andreas Säger wrote:
> Am 26.05.2012 22:13, Girvin R. Herr wrote:
>>>
>> Andreas,
>>
Andreas Säger wrote:
Am 26.05.2012 22:13, Girvin R. Herr wrote:
Andreas,
Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
connection type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
path and the MySQL 5.0.67 server.
Sun (Oracle) Java version
s Patrick still involved with packaging things for the slackware repos? If so then he might be worth contacting. Apparently he used to be very helpful and approachable.
Regards from
Tom :)
--- On Sat, 26/5/12, Girvin R. Herr wrote:
From: Girvin R. Herr
Subject: Re: [libreoffice-users] Re:
Am 26.05.2012 22:13, Girvin R. Herr wrote:
Andreas,
Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
connection type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
path and the MySQL 5.0.67 server.
Sun (Oracle) Java version 1.6.0_30
All test okay,
Andreas Säger wrote:
8><...
I was thinking of this problem which affects Linux+Java-DB+LibO before
3.5:
http://www.oooforum.org/forum/viewtopic.phtml?t=125253&highlight=java+linux
The problem has gone with LibreOffice 3.5 and it did not exist under
operating systems other than Linux.
drew jensen wrote:
8><...
Ah I missed that last bit - yup, those JDBC connections can suck - has
the OP tried ODBC?
//drew
Drew,
I am the OP.
No, I have not tried ODBC. The only configuration documentation I have
been able to get for MySQL and Base, used JDBC. At the time, that
docum
:)
--- On Sat, 26/5/12, Girvin R. Herr wrote:
From: Girvin R. Herr
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Saturday, 26 May, 2012, 20:43
drew jensen wrote:
> On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
>
&
Andreas Säger wrote:
Am 26.05.2012 00:47, Girvin R. Herr wrote:
As an update to my problem with Report Builder, my 1500+ record database
takes 94 pages of a Report Builder / Writer document. I put on my
patience hat and timed how long it takes to format the report, ready for
printing. As a ba
Andreas Säger wrote:
8><...
-- When you drag the query icon from the left pane of the data source
window onto a Calc cell you will get a semi-automatic link. Call
menu:Data>Refresh to refresh the link.
-- When you drag selected row selectors you get a copy of selected
rows. The top-left co
Fernand,
I am assuming you are talking about the "Data" tab for the report where
there are "Content Type" and "Content" option lists. I tried it both
ways with the same results. Originally, I was using the SQL command(s)
the wizard created when I first created the report. Those SQL commands
drew jensen wrote:
On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
drew jensen wrote:
8><...
Hi Tom
Really - you seem to know a lot, are you writing a manual?
@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - n
n that anyone else can cope with any of it.
Usually people that make something look easy have broken it down and worked
hard at each step to make it smoother and less liable to break or go wrong or
streamlined for speed.
Regards from
Tom :)
--- On Sat, 26/5/12, drew jensen wrote:
From:
Am 26.05.2012 13:32, drew jensen wrote:
On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote:
You are running the combination of Linux, Base plus JDBC?
Ah I missed that last bit - yup, those JDBC connections can suck - has
the OP tried ODBC?
//drew
I was thinking of this problem which
On Sat, 2012-05-26 at 12:53 +0200, Andreas Säger wrote:
> Am 26.05.2012 00:47, Girvin R. Herr wrote:
> >
> > As an update to my problem with Report Builder, my 1500+ record database
> > takes 94 pages of a Report Builder / Writer document. I put on my
> > patience hat and timed how long it takes to
Am 26.05.2012 00:47, Girvin R. Herr wrote:
As an update to my problem with Report Builder, my 1500+ record database
takes 94 pages of a Report Builder / Writer document. I put on my
patience hat and timed how long it takes to format the report, ready for
printing. As a baseline, it takes about 4
Am 26.05.2012 12:40, Andreas Säger wrote:
The linked data range resizes dynamically with every refresh.
Any formula cells directly adjacent to the import range will expand and
shrink with the resized data range. So the clearly defined row sets of a
database enable dynamically resizing formula ra
Dan,
Wow! That worked fine. Thanks.
However, I had to copy and paste the database data from the Data Source
window into the Calc spreadsheet. Is there a way to dynamically get the
current data to the spreadsheet so I don't have to cut and paste every
time I have new data?
If so, it would be a lot
Girvin ,
You must know that ORB , when openning a report, first execute the SQL
commands "saved" with the report, this can surrly takes some time, then
you can give a new 'actual)set off SQL commands. Therefore we never safe
the reports with real SQL commands, we just make a dummy command an
On Fri, 2012-05-25 at 19:02 -0700, Girvin R. Herr wrote:
>
> drew jensen wrote:
> 8><...
> >
> > Hi Tom
> >
> > Really - you seem to know a lot, are you writing a manual?
> >
> > @Girvin - there is no place that I've seen the report builder be that
> > slow and not have an installation problem - n
drew jensen wrote:
8><...
Hi Tom
Really - you seem to know a lot, are you writing a manual?
@Girvin - there is no place that I've seen the report builder be that
slow and not have an installation problem - not saying it is impossible
but sounds really odd. 1500 records in a tabular report, 4
Dan Lewis wrote:
Yes, you can link to a Base query with Calc. With Cal open, use the
F4 key to open the Data Source window. (You will have to register the
database before it will appear in this window.) The left side is the
name of the registered databases. Click the arrow in front of th
On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote:
>
> Tom Davies wrote:
> > Hi :)
> > I have just done a bit of digging around.
> >
> > Looking back through Andreas' answers
> > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80
> >
> > I found t
On Fri, 2012-05-25 at 15:47 -0700, Girvin R. Herr wrote:
>
> Tom Davies wrote:
> > Hi :)
> > I have just done a bit of digging around.
> >
> > Looking back through Andreas' answers
> > http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80
> >
> > I found t
Tom Davies wrote:
Hi :)
I have just done a bit of digging around.
Looking back through Andreas' answers
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=user_nodes&user=254826&i=80
I found this but i'm not sure it's much help for you
http://nabble.documentfoundation.org/da
Am 25.05.2012 10:04, Tom Davies wrote:
Sadly most of the people that know a lot about the ins-and-outs of Base are
unwilling to help write the Base guide so it's down to 1 person who is
desperately busy with a lot of other projects.
How would you write a guide for hammer, chisel, plow, saw
Am 25.05.2012 09:35, Tom Davies wrote:
Hi :)
I think there is another way to build reports? I think Andreas uses a
different way inside Base. Other people seem to start with the report builder
and then hack it around. It might be worth search the archives to find how
Andreas does reports!
R
Regards from
Tom :)
--- On Thu, 24/5/12, Girvin R. Herr wrote:
From: Girvin R. Herr
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 20:01
Andreas Säger wrote:
> With LibO 3.5 under Linux I can use
/12, Girvin R. Herr wrote:
From: Girvin R. Herr
Subject: Re: [libreoffice-users] Re: Extremely Slow Base Report Builder
To: users@global.libreoffice.org
Date: Thursday, 24 May, 2012, 20:01
Andreas Säger wrote:
> With LibO 3.5 under Linux I can use any recent Java version without any
>
Am 24.05.2012 21:33, Andreas Säger wrote:
Am 24.05.2012 21:01, Girvin R. Herr wrote:
I will certainly take your experience to heart and your recommendation
to update my Java.
Thanks again.
Girvin
If you are running Java 1.7 downgrading to some recent 1.6 version may
be even more helpful. Unt
Am 24.05.2012 21:01, Girvin R. Herr wrote:
I will certainly take your experience to heart and your recommendation
to update my Java.
Thanks again.
Girvin
If you are running Java 1.7 downgrading to some recent 1.6 version may
be even more helpful. Until now I could not test RB with Java 1.7 a
Alexander Thurgood wrote:
Le 24/05/12 00:01, Girvin R. Herr a écrit :
Hi Girvin,
MySQL 5.0.67
MySQL-connector-java-5.0.7-bin.jar
Sun Java 1.6.0u11
Oooh, very old and potentially highly exploitable version of Java there.
Is my current Report Builder problem caused by
Andreas Säger wrote:
With LibO 3.5 under Linux I can use any recent Java version without
any issues. I tested 1.6.22, 1.6.31 and 1.7. Any of these simply work
with my Java databases.
I avoid the report builder like illness. If you feel the need to dance
with this software diva then you should
Le 24/05/12 00:01, Girvin R. Herr a écrit :
Hi Girvin,
>MySQL 5.0.67
>MySQL-connector-java-5.0.7-bin.jar
>Sun Java 1.6.0u11
Oooh, very old and potentially highly exploitable version of Java there.
>
> Is my current Report Builder problem caused by this Java problem again?
Yes.
With LibO 3.5 under Linux I can use any recent Java version without any
issues. I tested 1.6.22, 1.6.31 and 1.7. Any of these simply work with
my Java databases.
I avoid the report builder like illness. If you feel the need to dance
with this software diva then you should do all calculations, fi
38 matches
Mail list logo
