Hi ,

Im using SQLBase Server 6.1.2 and trying to connect using JDBC Drivers
(found on SQLBase CD)
but i get always "00296 DBO IVC Backend code page is not same" error ;(
When i use sqltalk utility it runs without any problems.
Where is the problem? Please help

this is my sql.ini
-----------------------------------
[sqlapiw]
country=poland

[winclient]
clientname=CLI_IP16
connecttimeout=5
country=poland

[winclient.dll]
;comdll=sqlwsock
comdll=sqlspxw4

[winclient.nbiow]

[winclient.spxw4]

[winclient.wsock]
serverpath=start,192.0.3.2/,*
[win32client]
;clientname=stat(1148)
clientname=inf_broda
country=poland

[win32client.dll]
;comdll=sqlspx32
comdll=sqlws32
;comdll=sqlwsspx

[win32client.apipe]

[win32client.ntnbi]

[win32client.ws32]
serverpath=kadry,192.0.3.2/xxx,*

[win32client.spx32]

[win32client.wsspx]


[patch.comments]
;
; This section is only used if running the NLM Database Server on a
; NETFRAME machine.
;
[patch]

[sqltalk]
country=poland
-----------------------------------

party of my country.sql
-----------------------------------
[poland]
#whitespace
\9 \A \D \20
#numeric
0 1 2 3 4 5 6 7 8 9
#alpha
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z \A5 \C6 \CA \A3 \D1
\D3 \8C \AF \8F
a b c d e f g h i j k l m n o p q r s t u v w x y z \B9 \E6 \EA \B3 \F1
\F3 \9C \BF \9F
#lower
\A5 \B9
\C6 \E6
\CA \EA
\A3 \B3
\D1 \F1
\D3 \F3
\8C \9C
\AF \BF
\8F \9F
#upper
\B9 \A5
\E6 \C6
\EA \CA
\B3 \A3
\F1 \D1
\F3 \D3
\9C \8C
\BF \AF
\9F \8F
#translate
\B9 a{
\E6 c{
\EA e{
\B3 l{
\F1 n{
\F3 o{
\9C s{
\BF z{
\9F z}
\A5 A{
\C6 C{
\CA E{
\A3 L{
\D1 N{
\D3 O{
\8C S{
\AF Z{
\8F Z}
-----------------------------------

and part of my code

Connection con = null;
try {

Class.forName("com.centurasoft.java.sqlbase.Sqlbas eDriver").newInstance();
String s1 = "A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
\\A5 \\C6 \\CA \\A3 \\D1 \\D3 \\8C \\AF \\8F";
String s2 = "a b c d e f g h i j k l m n o p q r s t u v w x y z
\\B9 \\E6 \\EA \\B3 \\F1 \\F3 \\9C \\BF \\9F";
String s3 = s1.concat(s2);

com.centurasoft.java.sqlbase.SqlbaseDriver.SetCoun tryWhiteSpace("\\9
\\A \\D \\20");
com.centurasoft.java.sqlbase.SqlbaseDriver.SetCoun tryNumeric("0
1 2 3 4 5 6 7 8 9");
com.centurasoft.java.sqlbase.SqlbaseDriver.SetCoun tryAlpha(s1);
DriverManager.setLogStream(System.out);
con =
DriverManager.getConnection("jdbc:sqlbase://192.0.3.2:2155/rumkat","sysadm","sysadm");
if(!con.isClosed())
System.out.println("Successfully connected to SQLBase");
} catch(Exception e) {
System.out.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {
System.out.println("SQLException: " + e.getMessage());
}
}

full error message is:
DriverManager.getConnection("jdbc:sqlbase://192.0.3.2:2155/rumkat")
trying
driver[className=com.centurasoft.java.sqlbase.SqlbaseDriv er,com.centurasoft.java.sqlbase.SqlbaseDriver@19f9 53d]
java.sql.SQLException: 00296 DBO IVC Backend code page is not same,
check SQL.INI file and country.sql

ODBC Drivers run without problems
but i would like to use JDBC.

Thanks for any comments/solutions
Maciej G.