Hi
I am trying to use JDBC Test provided by Merant to
test the connectivity to DB2 datbase(UDB on Winodws NT)
Actually my ultimate aim is to get the data from DB2
databse which I have installed on Windows NT as an ETD in
my eGate schema. But rather than facing errors in the
middle of programming I would first like to test
first,whether I can achieve simple connectivity .
I gave the following URL in the jdbctest Merant utility to connect to db2 database. :-
jdbc:SeeBeyond:db2://localhost:50000;databaseName=SAMPLE;
collectionId=JDBCPKG=;packageName=JDBCPKG;embedded=true;
createDefaultPackage=TRUE;replacePackage=TRUE
and then entered UserName and password.
However I am getting following error :
getConnection() Failed:
Message: [SeeBeyond][DB2 JDBC Driver][DB2] Logon Error: DISTRIBUTION PROTOCOL ERROR:
REASON PRCCNVRM (SYNTAXRM),
check connection properties [/b]
Vendor: -30000
State: 58008
1> what should be the server name ? In above case I have given localhost because db2 is
locally installed on my machine.
2> My db2java.zip file is in the folder :-
D:\Program Files\IBM\SQLLIB\java
Can anybody help ?
I am trying to use JDBC Test provided by Merant to
test the connectivity to DB2 datbase(UDB on Winodws NT)
Actually my ultimate aim is to get the data from DB2
databse which I have installed on Windows NT as an ETD in
my eGate schema. But rather than facing errors in the
middle of programming I would first like to test
first,whether I can achieve simple connectivity .
I gave the following URL in the jdbctest Merant utility to connect to db2 database. :-
jdbc:SeeBeyond:db2://localhost:50000;databaseName=SAMPLE;
collectionId=JDBCPKG=;packageName=JDBCPKG;embedded=true;
createDefaultPackage=TRUE;replacePackage=TRUE
and then entered UserName and password.
However I am getting following error :
getConnection() Failed:
Message: [SeeBeyond][DB2 JDBC Driver][DB2] Logon Error: DISTRIBUTION PROTOCOL ERROR:
REASON PRCCNVRM (SYNTAXRM),
check connection properties [/b]
Vendor: -30000
State: 58008
1> what should be the server name ? In above case I have given localhost because db2 is
locally installed on my machine.
2> My db2java.zip file is in the folder :-
D:\Program Files\IBM\SQLLIB\java
Can anybody help ?