You can try the following command:
1.    open a new DOS window and enter cloudscape -start
2.    open a new DOS window and enter cloudscape -isql
3.    under "ij>" mode, then enter run 'createTable.sql'

The failure reason:
You didn't obtain the connection with cloudscape database.

----- Original Message -----
From: "Birendra Prasad" <biren@a...>
To: "Enterprise Java Beans" <enterprise_java_beans@p...>
Sent: Thursday, May 16, 2002 2:19 PM
Subject: [enterprise_java_beans] Help err : 08001: No suitable driver


Hi All !!

I am getting error while running an ejb example [professional EJB
chapter 4] with j2ee using default Cloudscape Database.
the details are:

MY CLOUDSCAPE classpath
---------------=-----------
D:\j2ee\lib\system\tools.jar;D:\j2ee\lib\cloudscape\RmiJdbc.jar;D:\j2ee\
lib\system\cloudscape.jar

NOTE: My J2ee server and Cloudscape database server both r running

IF I RUN a .sql script
----------------------
>java -Dij.connection.Cloudscape=jdbc:cloudscape:rmi:CloudscapeDB
-Dcloudscape.system.home=D:\j2ee\cloudscape -ms16m -mx32m
COM.cloudscape.tools.ij createTable.sql

MY ERROR :
--------------------------
ERROR 08001: No suitable driver
ij version 3.5 (c) 1997-2000 Informix Software, Inc.
ij> DROP TABLE TaxTable;
IJ ERROR: Unable to establish connection
ij> CREATE TABLE TaxTable (stateCode VARCHAR(3), taxRate REAL);
IJ ERROR: Unable to establish connection

My Resource.properties file in j2EE is
--------------------------
jdbcDataSource.0.name=jdbc/Cloudscape
jdbcDataSource.0.url=jdbc:cloudscape:rmi:CloudscapeDB;create=true
jdbcDriver.0.name=COM.cloudscape.core.RmiJdbcDriver
jdbcXADataSource.0.name=jdbc/XACloudscape
jdbcXADataSource.0.classname=COM.cloudscape.core.RemoteXaDataSource
jdbcXADataSource.0.dbpassword
jdbcXADataSource.0.dbuser
jdbcXADataSource.0.prop.createDatabase=create
jdbcXADataSource.0.prop.databaseName=CloudscapeDB
jdbcXADataSource.0.prop.remoteDataSourceProtocol=rmi
jmsCnxFactory.0.name=QueueConnectionFactory
jmsCnxFactory.0.isQueue=true
jmsDestination.0.name=jms/Queue
jmsDestination.0.isQueue=true


Pls help me out.

Thanx
-biren