-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
The driver needs to be able to see the SYBASE environment variable and/or
the \sybase\dll directory. Set the appropriate properties in the
jserv.properties file; they will probably look something like this:
wrapper.env=SYBASE=d:\sybase
wrapper.env=PATH=d:\sybase\dll;[... rest of path...]
If you already have these set up in the system environment, use
wrapper.env.copy instead:
wrapper.env.copy=SYBASE
wrapper.env.copy=PATH
This should get you going quickly. You really should use JConnect, though;
we've run into a couple of fairly nasty bugs with Callable/PreparedStatement
getting and setting functions with the Sybase ODBC drivers.
--Don Womick
> 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]
>
--
--------------------------------------------------------------
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]
