kathiste Posted February 5, 2008 Share Posted February 5, 2008 I need to connect to ODBC datasources.How have I to define:1) Driver (sun.jdbc.odbc.JdbcOdbcDriver, I suppose)2) URL Thank you. Link to comment Share on other sites More sharing options...
pilania Posted February 6, 2008 Share Posted February 6, 2008 use jDTS for connecting to MS SQL Server and Sybase http://jtds.sourceforge.net/ Link to comment Share on other sites More sharing options...
kathiste Posted February 6, 2008 Author Share Posted February 6, 2008 sorry, but I need to connect to MS Excel datasource. Link to comment Share on other sites More sharing options...
swood Posted February 11, 2008 Share Posted February 11, 2008 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. ShermanJasperSoft Link to comment Share on other sites More sharing options...
kathiste Posted February 13, 2008 Author Share Posted February 13, 2008 OKThe driver is located in C:ProgrammiJavajdk1.6.0_03jrebinJdbcOdbc.dllHow have I to set ODBJ driverURL (if I set URL=C:ProgrammiJavajdk1.6.0_03jrebinJdbcOdbc.dllI get the error in the attached log)Thanks [file name=odbcError.zip size=1597]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/odbcError.zip[/file] Link to comment Share on other sites More sharing options...
swood Posted February 13, 2008 Share Posted February 13, 2008 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 ShermanJasperSoftPost edited by: swood, at: 2008/02/12 21:26 Link to comment Share on other sites More sharing options...
madhukiran Posted August 6, 2010 Share Posted August 6, 2010 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:org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhaustedany help on this? Post Edited by madhukiran at 08/06/2010 08:35 Link to comment Share on other sites More sharing options...
swimpal Posted May 5, 2011 Share Posted May 5, 2011 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now