Here are the steps I followed:
1) I created the database in Cloudscape 5.1 and can use Cloudscape to access it and read the data find.
2) In my WSAD project, I created a database definition as follows:
Database Name: BooksDB
Database Vendortype: Cloudscape 5.1
3) I then attempted to create a new database connection as follows:
Connection Name: Con1
Database Name: BooksDB
User ID and password: Empty because the database doesn't have any
Database Vendortype: Cloudscape 5.1
JDBC Driver: Cloudscape Embedded JDBC Driver
Database Location: C:\Cloudscape_5.1\frameworks\embedded\bin\BooksDB
JDBC Driver Class: com.ibm.db2j.jdbc.DB2jDriver
Class Location: C:\Cloudscape_5.1\lib\db2jtools.jar;
C:\Cloudscape_5.1\lib\license.jar;
C:\Cloudscape_5.1\lib\db2j.jar
Connection URL:
jdbc
b2j:C:\Cloudscape_5.1\frameworkds\embedded\bin\BooksDB
Then when I click the finish button, I get the following message in WSAD 5.1:
IWAS0126E Problems encountered while trying to establish connection Con1 trying to connect to Con1
Reason: 'IWAS0223E The server at
'jdbc
b2j:C:\Cloudscape_5.1\frameworkds\embedded\bin\BooksDB' is not a
'Cloudscape, V5.1' database. Ensure the database vendor type currently
specified for the connection matches the version installed on the server
and try again.'
Thanks for all your help.
Mike Payne