Set ODBC datasource

0
I need to connect to ODBC datasources.
How have I to define:
1) Driver (sun.jdbc.odbc.JdbcOdbcDriver, I suppose)
2) URL

Thank you.
kathiste's picture
Joined: Nov 13 2007 - 5:24am
Last seen: 12 years 3 months ago

7 Answers:

0
use jDTS for connecting to MS SQL Server and Sybase

http://jtds.sourceforge.net/
pilania's picture
Joined: Jun 19 2007 - 3:44am
Last seen: 12 years 8 months ago
0
sorry, but I need to connect to MS Excel datasource.
kathiste's picture
Joined: Nov 13 2007 - 5:24am
Last seen: 12 years 3 months ago
0
The JDBC/ODBC driver is in the JDK.

You should be able to set up an ODBC data source on your Windows machine where JasperServer is running, and then create a JDBC data source in JasperServer that points to the ODBC data source. You just have to get the JDBC URL right in the JasperServer data source definition.


Sherman
JasperSoft
swood's picture
2552
Joined: Jun 21 2006 - 12:48pm
Last seen: 7 years 4 months ago
0
OK
The driver is located in
C:\Programmi\Java\jdk1.6.0_03\jre\bin\JdbcOdbc.dll
How have I to set
ODBJ driver
URL

(if I set URL=C:\Programmi\Java\jdk1.6.0_03\jre\bin\JdbcOdbc.dll
I get the error in the attached log)
Thanks
[file name=odbcError.zip size=1597]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/odb...
kathiste's picture
Joined: Nov 13 2007 - 5:24am
Last seen: 12 years 3 months ago
0
From http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html


The Bridge driver uses the odbc subprotocol. URLs for this subprotocol are of the form:

jdbc:odbc:<data-source-name>[;<attribute-name>=<attribute-value>]*

For example:

jdbc:odbc:sybase
jdbc:odbc:mydb;UID=me;PWD=secret
jdbc:odbc:ora123;Cachesize=300


Sherman
JasperSoft
Post edited by: swood, at: 2008/02/12 21:26
swood's picture
2552
Joined: Jun 21 2006 - 12:48pm
Last seen: 7 years 4 months ago
0

I am connecting to an Excel ODBC Datasource through JDBC-ODBC driver from JasperServer. When I test the connection, it says "Test Successful" but when i run the report with the excel datasource, it says the followign error:

<i>org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted</i>
 
any help on this?

 


Post Edited by madhukiran at 08/06/2010 08:35
madhukiran's picture
Joined: May 20 2009 - 1:53am
Last seen: 1 year 4 months ago
0

Hi, was wondering if you manage to connect and get it working, if yes, what is the password and username that an excel file need?

swimpal's picture
Joined: May 5 2011 - 12:36am
Last seen: 8 years 9 months ago
Feedback
randomness