Takyiu Liu wrote: > > [...] > The only problem is: now my Java APPLICATIONS can use jdbc-odbc > bridge. No problem, no warning whatsoever. But my SERVLETS's init() > function (where I create a pool of DB connections) would scream "Error > code: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data > source name not found and no default driver specified" error at me > consistently. > My question is: why? Why would a servlet's init() behave any > differently than a Java application's member function? I have never > seen anything like this, nor can anyone gives me any explanation. I > have written some other programs to access the same database with an > RMI server or a socket server through a jdbc-odbc bridge, they still > all work. EXCEPT my darnest servlets. None of them works. So, if > anyone can shed some light and point me in the right direction, I will > be most grateful. Any chance that the servlet engine run as a different user than your application? If so, are you sure your ODBC data source is defined as a System data source (System DSN) as opposed to a User DSN? Also make sure you don't have both a User DSN and a System DSN with the same name. -- Hans Bergsten [EMAIL PROTECTED] Gefion Software http://www.gefionsoftware.com ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
