Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem Connecting to ODBC Source

 
ernest fakudze
Ranch Hand
Posts: 216
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!!
 
Bosun Bello
Ranch Hand
Posts: 1510
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
ernest fakudze
Ranch Hand
Posts: 216
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
ernest fakudze
Ranch Hand
Posts: 216
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ah, got it working again. Had to go back to Tomcat 3.3. Why can't Tomcat 4 work properly???
 
Jessica Sant
Sheriff
Posts: 4313
Android IntelliJ IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic