Re: connect to Informix Client SDK JDBC, Solaris 251 SPARC

I don't know if you necessarily need to run jdbc.sql in every circumstance. Check the release notes. Also, there are other environment variables, such as INFORMIXDIR that I needed to set (I'm using online). Burhman Gates (gatesb@mail.wes.army.mil) wrote: : I have : Informix 7.1x SE : Solaris 2.5.1 on SPARC : latest Client SDK : JDK 1.1.6 : I'm having trouble making a connection. : Can you point me to documentation? : I can run an applet : I can get to existing DB directly (just not through JDBC) : Classpath includes informix.jar : LD_LIBRARY_PATH includes all the shared libraries. : Error given is : 22% java ExecuteSQL -d informix.api.jdbc.JDBCDriver : jdbc:informix-api-direct:database=/fullpath/dbname : informix.api.jdbc.JDBCException: XIX000:-329:Database not found or no : system permission. : SQL State: null : I tried running jdbc.sql : There were syntax errors in it. I'm not sure from the documentation : whether I'm supposed to : run it on each DB. : Has anyone had similar problems? : Thanks. : -- : Burhman Gates Voice: (601) 634-3200 : Research Engineer FAX: (601) 634-2764 : Waterways Experiment Station : 3909 Halls Ferry Rd.,Vicksburg MS 39180 -- ***************************************************************** * Wyan H. Jow * * "I remember how, in college I got that part-time job as a * * circus clown and the children would laugh and laugh at me. * * I vowed, then and there, that I would get revenge." * * - Jack Handey * *****************************************************************