Problem with new datasource

[abeermann]

Hello Everbody

I want to configure iReport 3.7.1  for working with MAXDB and Servoy

I followed the intructions:

I did options/classpath/addjar and entered the driver which i use with servoy.

c:\programme\servoy\application_server\drivers\sapdbc.jar

Now i want to create a new database connection.

new/ Database JDBC connection

But the sabdbc driver is not offered ???

There is a driver list with mysql,oracle,ms sql,postgre sql

no sapdbc ???

Any help welcomed

Best regards

Albert

[cbarlow3]

Maybe the options/classpath/addjar step you mention does the same thing, but when I have someone install iReport and they have to use a special database driver (IBM DB2 Universal Driver, in our case), I first have to register the database driver through the services window  as follows:

1. Make sure you know where the jar file is on your PC (in my case, it's a file called db2jcc.jar)

2. In iReport, Window | Services

3. Select databases node and expand it.

4. Select Drivers node, right click it, and select "New Driver"

5. Add the driver, using the "Browse" button to find the jar file.

 

From then on, when you add a new connection, you should change the dropdown "Name:" from the default of "JDBC-ODBC Bridge" to the database driver of your choice (which should appear in the dropdown now that you've registered it).

Hope that helps.

Carl