ODBC runs INTO JB but not OUT of it
Edilmar Alves
I made a servlet with JB4 Enterprise + Tomcat 3.2.1 that
needs to access a DBF legacy database.
If I run the servlet into JB, it queries the DBF files
with no problems. However, if I try to run independently
using Apache + Tomcat, it doesn't work.
If I use other databases (MySQL, Interbase, etc), the
db.OpenConnection() works fine too.
Then, I think this is a problem with configuration ODBC
databases with Tomcat.
At desparation idea, I put this JAR into wrapper.properties:
wrapper.class_path=d:\lp\jbuilder4\jdk1.3\jre\lib\rt.jar
that has the classes for ODBC, but none worked.
This is the configuration for ODBC:
- jdbc:odbc:Multiloja
- sun.jdbc.odbc.JdbcOdbcDriver
and it works fine with JDBC Explorer and Delphi SQL Explorer.
Below is the exception:
See com.borland.dx.dataset.DataSetException error code: BASE+66
com.borland.dx.dataset.DataSetException: [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified
at com.borland.dx.dataset.DataSetException.a(Unknown Source)
at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)
at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)
at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
at Comum.HttpServletGeral.OpenDatabases(HttpServletGeral.java:91)
at Comum.HttpServletGeral.jbInit(HttpServletGeral.java:69)
at multiloja.ServletMultiloja.init(ServletMultiloja.java:84)
at org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
at org.apache.tomcat.core.Handler.init(Handler.java:215)
at org.apache.tomcat.core.ServletWrapper.init(ServletWrapper.java:296)
at
org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(LoadOnStartupInterceptor.java:130)
at org.apache.tomcat.core.ContextManager.initContext(ContextManager.java:491)
at org.apache.tomcat.core.ContextManager.init(ContextManager.java:453)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
Chained exception:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2458)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:320)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at com.borland.dx.sql.dataset.Database.openConnection(Unknown Source)
at Comum.HttpServletGeral.OpenDatabases(HttpServletGeral.java:91)
at Comum.HttpServletGeral.jbInit(HttpServletGeral.java:69)
at multiloja.ServletMultiloja.init(ServletMultiloja.java:84)
at org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
at org.apache.tomcat.core.Handler.init(Handler.java:215)
at org.apache.tomcat.core.ServletWrapper.init(ServletWrapper.java:296)
at
org.apache.tomcat.context.LoadOnStartupInterceptor.contextInit(LoadOnStartupInterceptor.java:130)
at org.apache.tomcat.core.ContextManager.initContext(ContextManager.java:491)
at org.apache.tomcat.core.ContextManager.init(ContextManager.java:453)
at org.apache.tomcat.startup.Tomcat.execute(Tomcat.java:195)
at org.apache.tomcat.startup.Tomcat.main(Tomcat.java:235)
John B. Moore
> com.borland.dx.dataset.DataSetException: [Microsoft][ODBC Driver Manager] Data
source name
> not found and no default driver specified
>
Your driver class files are not on the Tomcat classpath OR your ODBC driver is not
installed on that machine and it therefore failed to instantiate. This is where you
need to look.
John..
+++++++++++++++++++++++
TeamB are volunteer helpers. Please do not email replies or questions. Post or reply
only on this newsgroup. Thank you.
For Papers on DataExpress, Applets, and Web Technologies go to:
http://www.microps.com/mps/papers.html
=======================