jQuery in Action, 3rd edition
The moose likes Servlets and the fly likes Problem Connecting to ODBC Source Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Problem Connecting to ODBC Source" Watch "Problem Connecting to ODBC Source" New topic

Problem Connecting to ODBC Source

ernest fakudze
Ranch Hand

Joined: Aug 27, 2001
Posts: 216
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
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1510
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?

So much trouble in the world -- Bob Marley
ernest fakudze
Ranch Hand

Joined: Aug 27, 2001
Posts: 216
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

Joined: Aug 27, 2001
Posts: 216
Ah, got it working again. Had to go back to Tomcat 3.3. Why can't Tomcat 4 work properly???
Jessica Sant

Joined: Oct 17, 2001
Posts: 4313

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??
I agree. Here's the link: http://aspose.com/file-tools
subject: Problem Connecting to ODBC Source
It's not a secret anymore!