473,320 Members | 1,862 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

nan
Hi All,
I am trying to connect the Database which is installed in AS400
using DB2 Client Version 8 in Windows box.
First i created the Catalog,

then when i selected the connection type as ODBC, then i am getting
following error, could any one please help in solving this issue?

ODBC connection failed.
[IBM][CLI Driver] SQL0332N There is no available conversion for the
source code page "1252" to the target code page "0". Reason Code "1".
SQLSTATE=57017


Thanks & Regards
Nanjayan

Dec 24 '05 #1
3 11971
nan wrote:
Hi All,
I am trying to connect the Database which is installed in AS400
using DB2 Client Version 8 in Windows box.

First i created the Catalog,

then when i selected the connection type as ODBC, then i am getting
following error, could any one please help in solving this issue?

ODBC connection failed.
[IBM][CLI Driver] SQL0332N There is no available conversion for the
source code page "1252" to the target code page "0". Reason Code "1".
SQLSTATE=57017

Nit: DB2 UDB for iSeries (AS/400) is part of the operating system
(OS/400). It is not "installed".

Below the text for iSeries message SQL0332 is shown. You might check
into the CCSID value assigned to the (iSeries) user profile you are
using to CONNECT. It may need to be changed if it is currently set to
0. Or if it is set to *SYSVAL use this command to check the value of
QCCSID system value: wrksysval qccsid
Just some things to look into...
wrkmsgd sql0332 qsqlmsg

Message ID . . . . . . . . . : SQL0332

Message file . . . . . . . . : QSQLMSG

Library . . . . . . . . . : QSYS

Message . . . . : Character conversion between CCSID &1 and CCSID &2
not valid.

Cause . . . . . : Character or graphic conversion has been attempted
for data that is not compatible. There is no conversion defined between
CCSID &1 and CCSID &2.

If one CCSID is 65535, the other CCSID is a graphic CCSID. Conversion is
not defined between 65535 and a graphic CCSID. If this is a CONNECT
statement, conversion is not defined between the default application
requester SBCS CCSID and the application server SBCS CCSID. If the
second CCSID is 0, the application server did not return its default
SBCS CCSID. An application server other than an iSeries may not support
a CCSID of 65535.
Recovery . . . : Ensure that all character or graphic comparisons,
concatenation, or assignments are between columns or host variables with
compatible CCSID values.
If this is a CONNECT statement, change either the SBCS CCSID of the
application requester or the application server, so conversion between
the CCSID values is defined.

--
Karl Hanson
Dec 27 '05 #2
Karl Hanson wrote:
Nit: DB2 UDB for iSeries (AS/400) is part of the operating system
(OS/400). It is not "installed".


If operating system on AS/400 was installed (in manufacturing or by customer; it
doesn't matter how) - then any part of it (for example DB2/400) was also
installed, right?

Jan M. Nelken
Dec 28 '05 #3
Jan M. Nelken wrote:
Karl Hanson wrote:
Nit: DB2 UDB for iSeries (AS/400) is part of the operating system
(OS/400). It is not "installed".

If operating system on AS/400 was installed (in manufacturing or by
customer; it doesn't matter how) - then any part of it (for example
DB2/400) was also installed, right?


Correct. There is no separate product to install for SQL etc. There
are some separate products such as 5722ST1 (Query Mgr & DevKit) that
provide for example an interactive SQL interface.

http://www.ibm.com/servers/eserver/i...b2/db2faq.html

Note: There are some optionally installable parts of OS/400, such as
Option 1 : Extended Base Support. However DB2 is not one of those.

--
Karl Hanson
Dec 28 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dmitry Bond | last post by:
Hi All. I'm trying to connect DB2 8.1 server remotely via DB2 7.2 Client Configuration Assistant. But is displays the following error message: ===error=== The search for databases on the...
12
by: Thames | last post by:
I just did some replication operations between remote DB on linux and local DB on windows yesterday It gave me such errors when I perform db connection via command line windows (local DB on...
2
by: Thames | last post by:
Hi, I have to repost my question for help. Yesterday I set up two DB UDB ESE V8.2 server on linux and windows platform, respectively. Both servers have been connected without any problems...
0
by: Yoav | last post by:
Hello, I have been trying to enter SQL statmenbts to DB2 control center command line. I saw that user "Thames" wrote to you: > I have to repost my question for help. > > Yesterday I set up two...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.