• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Tim Cooke
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Frank Carver
  • Henry Wong
  • Ron McLeod
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Himai Minh

WSAD 5.1 and Cloudscape 5.1

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am trying to connect to a Cloudscape 5.1 database in WSAD 5.1.

After I add databast to project, I get at error stating that the database is not a Cloudscape 5.1 database.

Any help would be appreciated.

Thanks,
Mike
 
author
Posts: 3892
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi -- this configuration does work -- I just did an example of it last week. Could you post both the exact error message you're receiving and the exact series of steps you're carrying out that leads to the message?

Kyle
 
Michael James Payne
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Evil is afoot. But this tiny ad is just an ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic