tomcat and servlet and ODBC driver

[henryhandle]

i am trying to use tomcat instead of
microsoft IIS.
I can startet servlets and
i can access an access database, which has
no pw and user name.
Now I have an Servlet, which will
connect to access database.
I get an error in Browser from
ODBC access Driver, that Password
is not correct
or no account exists.
My Question is, is there like IIS
a anynom USER in tomcat,because
i had the same Problem in
IIS until i got in registry the
IIS anynonm User tight to read
and to access database driver??

 

[sedj]

Its got nothing to do with Tomcat (or rather JDBC). Its however your ODBC datasource is set up ...

It might help if you showed your error stack trace, and JDBC connection URL.

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[henryhandle]

here the path and driver information:

String filename = "E:/main/eclipse/workspace/project/db1.mdb";
String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";SystemDB=E:/main/eclipse/workspace/project/ppp.MDW;DriverID=22;}


and the error:
ERROR: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] no zulässiger account or no zulässiges Password.
Connection con = DriverManager.getConnection( database ,"gooduser","goodpassword");

 

[sedj]

And are your user passwords for the db "gooduser" and "goodpassword" ?

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[henryhandle]

yes, i'm sure!!

 

[sedj]

Have a read through this and see if it helps :

http://www.javaworld.com/javaworld/javaqa/2000-09/03-qa-0922-access.html

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[henryhandle]

i get error from browser!!!
is that a valid link?

 

[sedj]

No, I gave you a bad link just for the fun of it

Yes, the link is valid !

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[henryhandle]

the connection String is correct.
i will see later what i can do!
I use instantaneous for testing
the database
without pwd and userid and
thanks for your hints!