-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
Greetings,
JServe 1.0b5
Apache 1.3.9
Windows NT patch level 4
System: MS Windows 4.0, Sybase ASE ODBC Driver Version 03.50.0000,
Apache Web Server w/ JServe 1.0, JDK 1.2, JDBC 2.0
User: Administrative Group rights
Problem: I've developed a Java Servlet that will query a remote Sybase
DBMS (on Solaris) using JDBC Bridge to ODBC driver. I have
The Apache Web Server installed to run as an NT Service with
the Java Servlet module JServe 1.0 installed.
During development, I created a User DSN to unit test my Java
code (not in Java Servlet form) to test my "end to end ODBC
connectivity" - everything worked fine.
Then I inserted my JDBC code into my Java Servlet and was
getting the following error from DriverManager.getConnection()
and seeing a Microsoft ODBC driver error. This made me
realize I needed to create a new "System DSN" because my
web server is running as an NT Service.
This got me past my first error, but now I'm getting another
error. In my error application context, the SQLexception is:
"specified driver could not be loaded due to system error 126
(Sybase ASE OBDC Driver)" SQL State: IM003 Error Code: 160
In the OBDC log generated by the Control Pannel Applet, the
Error is far more terse:
"63:132 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)"
Am I missing something here? I can query my RDBMS ok using my User DSN
with my straight Java code, but when I move the identical JDBC code into a
Java Servlet being served through Apache w/JServe 1.0 running as an NT
Service using a defined System DSN, I cannot establish a connection to the
DB.
Attatched is my JServ logfile
[28/09/1999 22:16:38:290 EDT] ApacheJServ/1.0 is starting...
[28/09/1999 22:16:38:290 EDT] WARNING: connection authentication is disabled
[28/09/1999 22:16:38:370 EDT] Connection allowed from localhost/127.0.0.1
[28/09/1999 22:16:38:370 EDT] Listening on port 8007 accepting 50 maximum
connections
[28/09/1999 22:16:38:390 EDT] Creating Servlet Zones
[28/09/1999 22:17:02:966 EDT] HelloWorld: init
[28/09/1999 22:17:03:056 EDT] HelloWorld: Exception: SQLException thrown
from DriverManager.getConnection
[28/09/1999 22:17:03:056 EDT] HelloWorld: SQL: java.sql.SQLException:
Specified driver could not be loaded due to system error 126 (Sybase ASE
ODBC Driver).
[28/09/1999 22:17:03:056 EDT] HelloWorld: SQL State: IM003
[28/09/1999 22:17:03:056 EDT] HelloWorld: Error Code: 160
Attatched is my JServ configuration has not been modified from the original
install.
Has anyone seen this behavior? Please let me know if I'm missing any
details or you require more info. I can be reached through email at:
[EMAIL PROTECTED]
thank you!
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
