hi,everyone here.
I developed a
Servlet program connecting to the Ms-access database via the JDBC-ODBC bridge bundled with Sun's JDK. It works fine in the NetBean4.1. Following is the Servlet code which gives you a general idea.
Basicaaly, this program connects to the database via JDBC-ODBC bridge and retrieves the data back to the client, works fine in the Netbean. And in the Netbean I do not bother with setting up the CATALINA_HOME, JAVA_HOME etc, just build and run the program, at this stage, everthing seems nice and cool.
Now, when I put this similar program into another computer which has the latest tomcat5.5.x only, the Servlet program doesn't work. Well, the client can access the Servlet program but stuck in the following code and can not get through the database connection.
I thought it was a
Tomcat setup problem but having seen the following link in the Tomcat FAQ: Database, my heart was broken.
Do not use JDBC-ODBC bridge Now what can I do to make the program work and can anybody tell the why the netbean do not have the same problem?
[ December 10, 2005: Message edited by: Jiafan Zhou ]