I have studied and tried all that I can think of to make my very simple servlet access an SQL Server database through a jdbc:odbc bridge. I created this servlet by modifying a working, standalone java class. Although the standalone version accesses the database and efficiently returns the correct data from the query, the servlet only gives the following error: SQLException: [Microsoft][ODBC SQL Server Driver][DBMSRPCN]General network error. Check your network documentation. I am using jdk1.2.1 and JRun 2.3 with IIS version 4. In searching the FAQs and archives, I found hints regarding the placement of the servlet in a directory other than /servlets/, and the inclusion of all files in the JRun classpath, but so far nothing works. I then copied the example of someone from this List who said using MS Access and the jdbc:odbc bridge was drop-dead simple. Unfortunately, even my MS Access data source did not work. The error read: SQLException: [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't find file 'D:\JRun\jsm-default\lifelink.mdb'. I don't know why it was looking for the database file in the JRun directory, since that was not where it was assigned in the ODBC source. Any suggestions as to what I might try next? ___________________________________________________________________________ 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
