I am trying to set up connection in iReport in Fishbowl inventory, but got the error message "Possible not found class: org.firebirdsql.jdbc.FBDriver", tried many ways suggested but none of them worked.
Here is my settings:
1. Install Fishbowl Inventory and iReport Designer on your system.
2.Add Jaybird jar file (FireBirdSql database driver) to the Classpath.
Tools –> Options –> iReport –> Classpath
3.Create a jdbc connection
JDBC driver - org.firebirdsql.jdbc.FBDriver
JDBC url - jdbc:firebirdsql://192.168.1.2:3050/C:\Program Files (x86)\Fishbowl\database\data\LWFLOORING.FDB
Username – gone
Password – fishing
Anything that I did wrong????
1 Answer:
I know this is a little late but... I had the exact same problem and I tried everything I could find on the web.
I was using java 6. I upgraded to java 7. Boom! Worked.
Also, I didn't put the port of the server, but I don't think that would matter since it looks like you are using the right port for this.
In my previous attempts to get it to work, I had already added the driver to services and copied the driver to ireport directory: /ide10/modules/ext/ but I'm not sure if that had anything to do with getting it to work.
Hope this helps someone.
