You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Slava <sl...@yahoo.com> on 2001/11/13 23:37:27 UTC
Tomcat 3.2.3 and MS Access.
Hello,
I'm accessing data base from login page.
When I starting Tomcat from startup.but everything working fine.
If I starting Tomcat from the Services I'm getting:
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 com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown Source)
at com.borland.dx.sql.dataset.o.a(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.e(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.h(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.a(Unknown Source)
at com.borland.dx.dataset.DataSet.open(Unknown Source)
at payroll.HeaderServlet.doPost(HeaderServlet.java:90)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java:287)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
at java.lang.Thread.run(Thread.java:484)
But Data Source Name is correct.
Maybe I miss some setting?
Can somebody help me?
Thanks.
__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>
RE: Tomcat 3.2.3 and MS Access.
Posted by Martin van den Bemt <ma...@isallineed.org>.
Best to check msn or technet on microsoft.com for this.. It seems like a
plain odbc error (too bad no errorcode is supplied), so something is
misconfigured for the user who runs tomcat as a service. If you search on
those things you probably end up with an answer..
Mvgr,
Martin
> -----Original Message-----
> From: Slava [mailto:slava40@yahoo.com]
> Sent: Wednesday, November 14, 2001 12:04 AM
> To: Tomcat Users List
> Subject: RE: Tomcat 3.2.3 and MS Access.
>
>
> Thanks for reply.
> I change datasource from user to system but it doesn't work anyway.
> Same error message.
> Maybe something else?
> Any help welcome.
> Thanks.
>
>
> --- Martin van den Bemt <ma...@isallineed.org> wrote:
> > As I remember from way back : datasources can be created a
> number of ways :
> > yours ir probably a user datasource and you need a system
> datasource (which
> > is as it says, known system wide). If you start tomcat.bat it
> will run as
> > you, if it starts as a service, it will start as whatever you
> defined, but I
> > guess it is not you ;))
> > You can get more feedback on this on a MS mailinglist..
> >
> > Mvgr,
> > Martin
> >
> > > -----Original Message-----
> > > From: Slava [mailto:slava40@yahoo.com]
> > > Sent: Tuesday, November 13, 2001 11:37 PM
> > > To: tomcat-user@jakarta.apache.org
> > > Subject: Tomcat 3.2.3 and MS Access.
> > >
> > >
> > > Hello,
> > > I'm accessing data base from login page.
> > > When I starting Tomcat from startup.but everything working fine.
> > > If I starting Tomcat from the Services I'm getting:
> > >
> > > 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
> > > com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknow
> > > n Source)
> > > at com.borland.dx.sql.dataset.o.a(Unknown Source)
> > > at com.borland.dx.sql.dataset.o.d(Unknown Source)
> > > at com.borland.dx.sql.dataset.o.e(Unknown Source)
> > > at com.borland.dx.sql.dataset.QueryProvider.h(Unknown Source)
> > > at
> > > com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
> > > at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
> > > at com.borland.dx.dataset.DataSet.a(Unknown Source)
> > > at com.borland.dx.dataset.DataSet.open(Unknown Source)
> > > at payroll.HeaderServlet.doPost(HeaderServlet.java:90)
> > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > > at
> > >
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
> > > at org.apache.tomcat.core.Handler.service(Handler.java:287)
> > > at
> > > org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> > > at
> > > org.apache.tomcat.core.ContextManager.internalService(ContextManag
> > > er.java:812)
> > > at
> > > org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
> > > at
> > > org.apache.tomcat.service.connector.Ajp12ConnectionHandler.process
> > > Connection(Ajp12ConnectionHandler.java:166)
> > > at
> > >
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> > > at
> > >
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
> > > at java.lang.Thread.run(Thread.java:484)
> > >
> > > But Data Source Name is correct.
> > > Maybe I miss some setting?
> > > Can somebody help me?
> > > Thanks.
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Find the one for you at Yahoo! Personals
> > > http://personals.yahoo.com
> > >
> > > --
> > > To unsubscribe: <ma...@jakarta.apache.org>
> > > For additional commands: <ma...@jakarta.apache.org>
> > > Troubles with the list: <ma...@jakarta.apache.org>
> > >
> > >
> >
> >
> > --
> > To unsubscribe: <ma...@jakarta.apache.org>
> > For additional commands: <ma...@jakarta.apache.org>
> > Troubles with the list: <ma...@jakarta.apache.org>
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Find the one for you at Yahoo! Personals
> http://personals.yahoo.com
>
> --
> To unsubscribe: <ma...@jakarta.apache.org>
> For additional commands: <ma...@jakarta.apache.org>
> Troubles with the list: <ma...@jakarta.apache.org>
>
>
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>
RE: Tomcat 3.2.3 and MS Access.
Posted by Slava <sl...@yahoo.com>.
Thanks for reply.
I change datasource from user to system but it doesn't work anyway.
Same error message.
Maybe something else?
Any help welcome.
Thanks.
--- Martin van den Bemt <ma...@isallineed.org> wrote:
> As I remember from way back : datasources can be created a number of ways :
> yours ir probably a user datasource and you need a system datasource (which
> is as it says, known system wide). If you start tomcat.bat it will run as
> you, if it starts as a service, it will start as whatever you defined, but I
> guess it is not you ;))
> You can get more feedback on this on a MS mailinglist..
>
> Mvgr,
> Martin
>
> > -----Original Message-----
> > From: Slava [mailto:slava40@yahoo.com]
> > Sent: Tuesday, November 13, 2001 11:37 PM
> > To: tomcat-user@jakarta.apache.org
> > Subject: Tomcat 3.2.3 and MS Access.
> >
> >
> > Hello,
> > I'm accessing data base from login page.
> > When I starting Tomcat from startup.but everything working fine.
> > If I starting Tomcat from the Services I'm getting:
> >
> > 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
> > com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknow
> > n Source)
> > at com.borland.dx.sql.dataset.o.a(Unknown Source)
> > at com.borland.dx.sql.dataset.o.d(Unknown Source)
> > at com.borland.dx.sql.dataset.o.e(Unknown Source)
> > at com.borland.dx.sql.dataset.QueryProvider.h(Unknown Source)
> > at
> > com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
> > at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
> > at com.borland.dx.dataset.DataSet.a(Unknown Source)
> > at com.borland.dx.dataset.DataSet.open(Unknown Source)
> > at payroll.HeaderServlet.doPost(HeaderServlet.java:90)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > at
> > org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
> > at org.apache.tomcat.core.Handler.service(Handler.java:287)
> > at
> > org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> > at
> > org.apache.tomcat.core.ContextManager.internalService(ContextManag
> > er.java:812)
> > at
> > org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
> > at
> > org.apache.tomcat.service.connector.Ajp12ConnectionHandler.process
> > Connection(Ajp12ConnectionHandler.java:166)
> > at
> > org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> > at
> > org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
> > at java.lang.Thread.run(Thread.java:484)
> >
> > But Data Source Name is correct.
> > Maybe I miss some setting?
> > Can somebody help me?
> > Thanks.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Find the one for you at Yahoo! Personals
> > http://personals.yahoo.com
> >
> > --
> > To unsubscribe: <ma...@jakarta.apache.org>
> > For additional commands: <ma...@jakarta.apache.org>
> > Troubles with the list: <ma...@jakarta.apache.org>
> >
> >
>
>
> --
> To unsubscribe: <ma...@jakarta.apache.org>
> For additional commands: <ma...@jakarta.apache.org>
> Troubles with the list: <ma...@jakarta.apache.org>
>
__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>
RE: Tomcat 3.2.3 and MS Access.
Posted by Martin van den Bemt <ma...@isallineed.org>.
As I remember from way back : datasources can be created a number of ways :
yours ir probably a user datasource and you need a system datasource (which
is as it says, known system wide). If you start tomcat.bat it will run as
you, if it starts as a service, it will start as whatever you defined, but I
guess it is not you ;))
You can get more feedback on this on a MS mailinglist..
Mvgr,
Martin
> -----Original Message-----
> From: Slava [mailto:slava40@yahoo.com]
> Sent: Tuesday, November 13, 2001 11:37 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Tomcat 3.2.3 and MS Access.
>
>
> Hello,
> I'm accessing data base from login page.
> When I starting Tomcat from startup.but everything working fine.
> If I starting Tomcat from the Services I'm getting:
>
> 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
> com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknow
> n Source)
> at com.borland.dx.sql.dataset.o.a(Unknown Source)
> at com.borland.dx.sql.dataset.o.d(Unknown Source)
> at com.borland.dx.sql.dataset.o.e(Unknown Source)
> at com.borland.dx.sql.dataset.QueryProvider.h(Unknown Source)
> at
> com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
> at com.borland.dx.dataset.StorageDataSet.a(Unknown Source)
> at com.borland.dx.dataset.DataSet.a(Unknown Source)
> at com.borland.dx.dataset.DataSet.open(Unknown Source)
> at payroll.HeaderServlet.doPost(HeaderServlet.java:90)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
> at org.apache.tomcat.core.Handler.service(Handler.java:287)
> at
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextManag
> er.java:812)
> at
> org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
> at
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.process
> Connection(Ajp12ConnectionHandler.java:166)
> at
> org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
> at java.lang.Thread.run(Thread.java:484)
>
> But Data Source Name is correct.
> Maybe I miss some setting?
> Can somebody help me?
> Thanks.
>
> __________________________________________________
> Do You Yahoo!?
> Find the one for you at Yahoo! Personals
> http://personals.yahoo.com
>
> --
> To unsubscribe: <ma...@jakarta.apache.org>
> For additional commands: <ma...@jakarta.apache.org>
> Troubles with the list: <ma...@jakarta.apache.org>
>
>
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>