If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > CLI Connection Failed

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-19-07, 04:32
shanmugapriya shanmugapriya is offline
Registered User
 
Join Date: Jan 2007
Posts: 11
CLI Connection Failed

Hi All,

I am using DB2 V8.1(on windows XP) to connect DB2 V8.1 (On AIX).
While I catalog the server DB through the Configuration Assistant and test the connection,I get the following error.

CLI connection failed.

SQL0332N There is no available conversion for the source code page "1252" to the target code page "UNKNOWN". Reason Code "1". SQLSTATE=57017

Kindly advice.

Thanks ,
Priya
Reply With Quote
  #2 (permalink)  
Old 01-19-07, 05:19
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
ccsid

try on aix server
db2 get db cfg for dbname
and check
Database territory
Database code page
Database code set
the message indicates, there is no conversion possible from 1252
the db seems to be in another group of languages.
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #3 (permalink)  
Old 01-19-07, 05:22
shanmugapriya shanmugapriya is offline
Registered User
 
Join Date: Jan 2007
Posts: 11
guyprzytula,

Exactly ,i too checked that.
hence the following information.
Database territory = TH
Database code page = 874
Database code set = TIS620-1

But what changes should I do to the client to connect to the server?

Also that the server is on SSH.

Thanks,
Priya
Reply With Quote
  #4 (permalink)  
Old 01-19-07, 05:52
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
ccsid

have a look at this
http://www-128.ibm.com/developerwork...0209kline.html
and try with setting db2codepage
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On