Re: JDBC Demo Error

I also ran the basic demo and got the following error messages. >ERROR: failed to connect! >ERROR: Attempt to connect to database server (%s) failed. >java.sql.SQLException: Attempt to connect to database server (%s) failed. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:160) at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:346) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:187) at java.sql.DriverManager.getConnection(DriverManager.java:91) at java.sql.DriverManager.getConnection(DriverManager.java:149) at CreateDB.main(CreateDB.java:58) I have double checked the user and password I passed to CreateDB. I can run dbaccess to connect to the informix server and do many other sql jobs without problems. System: S.u.S.E 5.2 Any hint will be appreciated. David Zhong dz@tpgusa.com Frank Riha wrote: > Hi, > > Installed Informix SE on Redhat 5.1 (glibc). All went well. Set up 3 > databases using dbaccess, dbaccessdemo7, and my own SQL -- attached > via named pipe server and through tcp sockets. > > Installed the JDBC driver, ran demo1, and got the following outpu: > > >Driver loaded...and connection established > >Could not create database.... > >Syntax disallowed in this database server. > >Could not populate database.... > >Database not selected yet. > > What does this mean? > > Apologies if this is an obvious problem, but I have failed to find a > reference to it. > > TIA > > Frank Riha