-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
Greetings,
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.
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]
