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

Burhman Gates wrote: > > Yes. I found a solution. I quit using Informix and began using > PostgreSQL. > I found that support is easier to come by. > > Subject: JDBC and Informix > Date: Wed, 15 Jul 1998 04:34:12 -0500 > From: "Brendan Doherty" <bdoherty@motiv.co.uk> > To: bgates@corvette.wes.army.mil > I think I'm getting the same error message as you posted to > comp.databases.informix namely, > > SQLException weblogic.jdbc.informix4.InformixException: Informix error: > -329 > minor code=[0] [Error setting database to intranet] See Informix error > codes for > explanation > I'm using a pure Java JDBC type 4 driver (beta from weblogic). I have a > feeling > it's got something to do with the informix permissions, did you ever > find a > solution to the problem? Burham's snide remarks aside. The SQL error -329 indicates that the database will not permit you to connect to it or that the database does not exist. Assuming you know the name of your database, you must have the DBA or database owner GRANT CONNECT TO <jdbc_use_name or PUBLIC>; so that you will have permissions on the database. It is that simple! Art S. Kagel