Database Connections - Axis

[jenn sie]

I am using Axis and Tomcat and trying to get Access database content.

I can connect and print out info from the database outside of Axis using Java. But I am getting an error in my Tomcat window that says:

SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

It works fine outside my axis application. I think it may be the classpath, because I have had problems with that and have to type in the following to execute my client:

java -cp .;%AXISCLASSPATH% SearchRoomsClient -lhttp://localhost:8080/axis/servlet/AxisServlet -uuser1 -wpass1

If someone can please tell me what I should have in my classpath (if this is the problem), let me know.

Thanks
jenn

[Balaji Loganathan]

Originally posted by jenn sie:

java -cp .;%AXISCLASSPATH% SearchRoomsClient -lhttp://localhost:8080/axis/servlet/AxisServlet -uuser1 -wpass1

Thanks
jenn

What is this -uuser1 and -wpass1, is that the username and password for database access ?