Adding Sybase IQ driver to Jasper iReport

How to Add Sybase IQ to ireport 4 Linux.

Get jconnect60.jar (Sybase IQ Driver)
Put Driver into  /iReport-4.0.1/ireport/modules/ext/
In iReport go to Tools/Options
Go to iReport option
Go to Classpath tab
Click add JAR
Browse to find Driver in /iReport-4.0.1/ireport/modules/ext/
and select jconnect60.jar
Select ok.
Driver added.

Now when you add data source

Use com.sybase.jdbc3.jdbc.SybDataSource as your jdbs Driver
and jdbc:sybase:Tds:localhost:2638/MYDATABASE as your URL

Jasper iReport 4.0.1 fonts for linux

Okie dokie,

Well first tiny little blog showing how to add some java machine fonts for ubuntu linux (ubuntu 10 and above).

I had updated my machine to linux Mint 10 kde as well as updated iReport to 4.0.1.
When I opened a report I had created previously, I could not run the report as I was getting java errors in iReport :
net.sf.jasperreports.engine.util.JRFontNotFoundException: Font 'Arial' is not available to the JVM. See the Javadoc for more details.

A little research began and a solution was found.
It was quite basic to install.

You need to run this command : $sudo apt-get install msttcorefonts
Obviously you need to accept the questions during install
and then restart your Jasper iReport.

Now back to work...

THE START!!

Well here I go my first BLOG.
I will be using this site as a storage place for information or projects I collect or complete or want to complete while learning the craft of IT.
So if you have advice on a project please don't hesitate to pipe up and spread your wisdom in a comment.

I will attempt to write one piece a week and maybe more if I feel like the TV is boring me and there is no rugby on.
Hopefully I can help you or others in finding information that normally took me a search or more to discover.

Please comment on the articles and if you have questions I will attempt to answer the best way I know how.