LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 10-26-2003, 07:18 PM   #1
Ronw
Member
 
Registered: Sep 2003
Location: Auckland New Zealand
Distribution: SuSe 10.2 & SLED 10
Posts: 48

Rep: Reputation: 15
MYSQL Reports


Coming from a Windows and xbase background. I want to be able to run small databases in Linux similar to what I could od with Dbase, Paradox or Access. MYSQL seems to be the choice of relational databases and I can get around in there slowly. But what does one do for report writer. Do I have to use a 3rd party product. IS there a crystal report alternative for Linux?. How about if I want to output some labels from the database. OpenOffice Org does not seem to have any easy method of talking to MYSQL.
Any suggestions?
 
Old 01-19-2004, 11:45 AM   #2
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
Nevrona Rave Reports are supposed to work with Linux. A copy of 4.5 came on a separate disc with my copy of Borland's Kylix 3, but I have never been able to get it to install.
 
Old 01-20-2004, 12:31 PM   #3
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
This is VERY easy to do with Open Office 1.1

You need to install 1.1 OpenOffice, Java, mysql-connector-java-3.0.9-stable. These allows printing of Avery Labels and all the various types like visiting cards and so forth. No problem.
 
Old 01-20-2004, 12:39 PM   #4
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
Printing from Linux

Thanks, Buttersoft. Does it work as easily from Postgres, which is what I'm using (in addition to SQLite)? I'll try it in December for labels, but more immediately I need to replace the stock portfolio reports I used to do in Delphi using Paradox tables; had tdo quit because, having already decided to get rid of Windows, it broke down and wouldn't reinstall. Postgres is much better than Pdox tables, but printing to OO from it is something of a pain. I'm trying to adapt ReportBuilder from Delphi but keep finding files missing, (especially .dcu).
 
Old 01-20-2004, 12:52 PM   #5
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
It can handle ODBC/JDBC/MySQL/Adabas/Dbase thos are the main choices. I have not used Postgres.

Paradox on windows was brilliant. I had everything in that up to the point of switching to Linux 6-8 months ago.

OO 1.1. and Mysql work very well together.

Another thing for you to try Knoda that connects to Postgres.

Another thing for you to try :- http://www.ems-hitech.com/pgmanager/

I use the MySQLManager from EMS and it is a brilliant report-generator to many formats, perhaps their Postgres Manager is for you the solution?

Last edited by buttersoft; 01-20-2004 at 12:58 PM.
 
Old 01-20-2004, 03:36 PM   #6
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
Thanks! I've just donwloaded it. Can't really afford the $95 right now, but maybe by the time the 30 days are up . . .
 
Old 01-20-2004, 03:45 PM   #7
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
Bet you like it enough after 30 days! I lasted about 12 with the mySQL version. It is VERY useful. If my memory serves me correctly they have programmed it with Delphi....interesting.
 
Old 01-20-2004, 04:44 PM   #8
jdtiede
Member
 
Registered: Apr 2003
Location: Baton Rouge, LA
Distribution: Kubuntu 12.04, 12.10, 13.04a
Posts: 244

Rep: Reputation: 30
I have installed it but haven't been able to make it connect. I have no trouble connecting with psql, the postgres command line interface.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock welery Linux - Software 19 03-06-2014 08:19 AM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 02:52 AM
Problems with MySQL on SuSE: Can't Connect (/var/lib/mysql/mysql.sock) neocookie Linux - Software 8 02-08-2008 12:48 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM


All times are GMT -5. The time now is 10:02 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration