WebSphere Studio JDBC Connection Problem

[Christian Haag]

Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

[ulrike b]

Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

Hallo Christian,
have you solved this problem by now?
I have the same problem with Oracle8i 1.7.0.
With SQL+ I get a connection to my database
on the server, but not with WebSphere Studio?
Can you help me?
Ulrike

[shiva shankar]

Do you know what version of db2 the websphere portal requires ? Check out the version of JDBC too. If its JDBC 2 u need to upgrade it
Regds

[calimer22]

If someone have a solution because I have the same problem and I don't find the solution

[quasifu]

You must add the classes to your classpath, then restart your studio or WSAD. For example, if you are trying to connect to an Oracle db, you must add classes12.zip to your classpath in your system environment, then reopen studio or wsad.

[dinis]

Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

i got the same error message if someone solved it or got an idea?

[Nigel Kat]

I'm getting the same thing when going from WSAD running under NT to a Sybase ASE V12.5 server on a RS/6000.
I've verified the server & can connect just fine from code run outside of WSAD, which would prove that the drivers (jConnect V5.5) are loaded into the classpath since I don't do any cp definitions at runtime.
The Sybase ASE V12.5 and the UDB V7 options are included in the connection wizard under WSAD. I believe I saw a couple others in this message that are also there.
I posted a similar message to the IBM WSAD board about a month ago while they had one of the WSAD developers answering the quesions, but I never saw a response. I figured it was because I was heading to a Sybase server.
If anybody comes up with anything, please post.
Thx
Kat
>^..^<

[Nigel Kat]

In working with my WAS admin, they opened a PMR for this issue to IBM. The following:
****************
Thank-you for reporting this issue to WebSphere Studio Application
Developer Support and Services. I have opened a defect report JR 17393 for
investigation on this issue. As a workaround has been provided. May we
close the pmr?
**************
was the intial response from the IBM rep, note the defect report number for follow-up on a future patch/fix pack. If you would like to add your issues to this or open a separate one and reference this report number, contact the IBM site for problem reports.
The work around we received is:
******************
I noticed that when selecting the JDBC driver to equal jConnect 5.x JDBC Driver rather than Other Sybase Driver I receive the same error message you are seeing. I was able to connect to the Sybase bye selecting the JDBC driver to use Other Sybase Driver and configure the database connection wizard appropriately:
=====================
Connection name: Con1
Database myDatabaseName
User ID: myUserId
Pasword:******
Database ventor type: Sybase Adaptive Server Enterprise, V12
JDBC driver: Other Sybase Driver
JDBC driver class: com.sybase.jdbc2.jdbc.SybDriver
Class location: C:\jconn2.jar <---I used jconnect55.zip<br /> Connection URL: jdbc:sybase:Tds:[HOST]:[PORT]/[DATABASE NAME]<br /> =====================<br /> *************************<br /> There are 'other' drivers for the products shown in the previous posts as well. Try using some of those & see if you can get the connection to work.<br /> Good Luck!!<br /> >^..^<
Kat

[Rainer Typke]

I had the same problem as the original poster.
The solution was quite simple:
Pick the driver for the right OS, i. e. NOT the one on the client, but that of the server where the database runs.
In my case, I had to pick the "IBM DB2 APP driver for SOLARIS" even though I am running WSAD on Windows NT.

[Piotr Gucwa]

Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

I had the same problem and solved it by selecting "Other DB2 Driver",
also entered in right places:
COM.ibm.db2.jdbc.app.DB2Driver
C:\Program Files\SQLLIB\java\db2java.zip
jdbc b2:<my database>
pg

[Phil The Thrill]

Hi,
I took a look at your solution...

I had the same problem and solved it by selecting "Other DB2 Driver",
also entered in right places:
COM.ibm.db2.jdbc.app.DB2Driver
C:\Program Files\SQLLIB\java\db2java.zip
jdbc b2:

and I gave it a try but it doesn't work. The error I get is "No Suitable Driver"
any ideas?

[Kumar Sampath]

URGENT !!! URGENT !!! URGENT !!!
Hi
I am using the Webspshere studio Application developer 5.0 and iam very much new to the websphere studio application developer 5.0.When i try to debug on server ,its trying to start the test enviornment server but in the middle i am getting error in the console as follows:-
java.lang.NoDefClassFoundException
Exception in thread "main"
I can come to a conclusion that its relAted to some runtime environment.
Do i need to install Java SDK version 1.3 or greater also?
I WOULD APPRECIATE IF ANYONE CAN HELP ME OUT AS I NEED FINISH THIS WITH TIGHT DEADLINES.

Regards
Sampath

[Vidya Ram]

Hi all,
I'm replying to a very old thread because there is no solution posted for this problem yet and I have the same problem. When I try for JDBC DB2 8.1 connection in WSAD5.0, I get an error "No suitable driver".
I made sure that the classpath is set properly in the system environment.
Any help?
TIA,
Vidya.

Originally posted by Phil The Thrill:
Hi,
I took a look at your solution...

and I gave it a try but it doesn't work. The error I get is "No Suitable Driver"
any ideas?

[Vidya Ram]

I got the solution to this "No suitable driver" problem. Its because of the incompatibility in the version of db2locale.dll file in WSAD and DB28.x. The solution is posted in the following IBM link:
http://www-1.ibm.com/support/docview.wss?uid=swg21111633
-Vidya.

[Brian Kennedy]

Regarding 'no suitable driver found'. I was receiving same message 'not a db2 database' and decided to switch to 'other db2 driver' as suggested in several posts. I noticed that when I did this, the error message switched to 'no suitable driver' from 'not a db2 database'. Then I noticed the 'db2' node in the connection url string had been dropped by the wizard when you select 'other db2 driver'. So I added it back in and BINGO Houston we have connection! jdbc b2:SAMPLE

Hope this may help someone else. I've been struggling with this off and on for some time made all the more frustrtating as I was able to connect Visual Age for Java but wanted to migrate to WASD. This concept might also apply to newer versions of the WASD and database? Don't know but you might try.

[Praveen Dharmavaram]

I did get a "no suitable driver found" exception when connection from WSAD5.1 to a remote DB2 DB(V 7.2.10). I have a DB2 Client running on my Windows machine and there is a directory called Java12 in which there is a script to enable jdbc 2.0 which should be executed before acessing the DB. If i remember correctly its called "usejdbc2.bat".you can give it a try.
Good Luck
Praveen

[virendra balaut]

Originally posted by Christian Haag:
Hello,
i'm trying to get a connection from WebSphere Studio Application Developer (on NT) to a DB2 V7.2 (on Linux) using the NET Driver. The jdbctest Program from the IBM Homepage is running successfully after I copied the db2java.zip from the Linux to the NT machine. But when I try to get the same connection with Studio I'm getting the error message:
IWAS0126E Problems encountered while trying to establish connection Con1. Reason: 'IWAS0223E The server at 'jdbc b2://192.168.41.72:6789/db2samp' is not a 'DB2 UDB V7.2' database. Ensure the Database Vendor Type matches the version installed on the server and try again.'
The database in fact IS a DB2 UDB V7.2. So what can I do?

have u solved this problem i m havng same problem in window

[nowait shen]

hi,Vidya Ram
Thanks for your great message~~~
I had been stuck in the problem for almost one afternoon before I finally saw your message~
I think IBM should put the link of this error-handling page right on the DB2's homepage!!

[suria]

Vidhya, nice work. Helped me @ right time. Tks for the effort.

[Balaji Narasimhulu]

Vidhya,

The solution you posted solved the problem.

Regards,
Balaji

[Jignesh Patel]

but this solutions works for DB2 not for SQL Server 2000.
I am trying to use sqljbcd driver 2005 for connection and it says problem for loading driver.

Any idea?

[Cameron Wallace McKenzie]

Check to see if you have a usejdbc2.bat file on your computer, and if you do, run it.

Sounds like a driver issue to me.

-Cameron