Hi to all Ranchers! I have been connecting to an MS Access DSN for months now using JSP and Servlets but suddenly it won't work anymore. I get a message saying that the source could not be found. However, the strange thing is that I can connect to the source when using a normal Java class to connect to it. This is very confusing and maybe somebody could tell me what's wrong? Please help!!
In a time of drastic change it is the learners who inherit the future. The learned usually find themselves equipped to live in a world that no longer exists.<br />Eric Hoffer
What server/servlet engine are you using. Something must have changed since you mentioned that you could connect to it before. Did the DS name change or something?
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Joined: Aug 27, 2001
Thanks Bosun. You are probably right in saying that something must have changed somewhere. I think I upgraded to Tomcat 4 from 3.3. Could that be the problem? Yes, I did use to have problems with Tomcat 4 in the beginning because it refused to run but I finally got it to work. Now I think I'm positive that the problem is Tomcat 4. So I will downgrade to Tomcat 3 and hopefully things should work fine again. What does anybody think about this?
Joined: Aug 27, 2001
Ah, got it working again. Had to go back to Tomcat 3.3. Why can't Tomcat 4 work properly???
Check out this thread in the JDBC forum: JDBC-ODBC. Especially this post:
Originally posted by Jamie Robertson: You might want to look at this link to find out the limitations of the jdbc odbc bridge. As Paul stated earlier, this is a direct quote from Sun: "Note, however, that you should use the JDBC-ODBC Bridge only for experimental prototyping or when you have no other driver available." I'm sure that what you are trying to acclomplish can be done, in some way, as anything is possible...but it may take more time and effort than you may be willing to put into it. If your looking for an answer to your question like "Yes, it can be done...this is how", then I think you're out of luck...unless anyone else has suggestions?? Jamie