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!!
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??