?
Solved

Arabic Data From as400 To PC

Posted on 2004-04-18
14
Medium Priority
?
1,940 Views
Last Modified: 2012-08-13
Hi

We have a iseries server with OS400 V5R2 and arabic as a secondry language,now arabic is working fine and data is stored and retrived  in correct format if we use as400 programs but if we use pc program like vb or others to acess this as400 data through client access odbc connection we are getting garbage ,is there any solution for this.

Thanks
0
Comment
Question by:Mohd_Farooqui
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
14 Comments
 
LVL 33

Expert Comment

by:shalomc
ID: 10857120
Hey,
That's a similar problem to systems supporting hebrew, and that's a language I'm familiar with.
What is the system CCSID?
What is the user's CCSID?
What is the database file's CCSID?

ShalomC
0
 

Author Comment

by:Mohd_Farooqui
ID: 10857788
Thanks Shalomc for your reply

The CCSID for the system is 65535
In QCHRID the code page is 420 which is arabic
The CCSID for user is 420(arabic)
Database file CCSID is default .

 
0
 

Expert Comment

by:AFouad
ID: 10858071
Hi Mohd.

Before using ODBC with any other external Developing tool like VB specially with Arabic you have to verify that ODBC do not Translate the data...

1- Open the ODBC drive you have created
2- Select "Translate" Tab
3- Check "Do not translate CCSID 65535" radio box

AFouad
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Expert Comment

by:AFouad
ID: 10858220
Hi Mohd.

Sorry I missed up ... I meant the opposite

Check "Translate CCSID 65535" radio box

Sorry

AFouad
0
 

Author Comment

by:Mohd_Farooqui
ID: 10861706
Thanks Fouad,

But This option is already Checked ,but the problem is same.
0
 

Expert Comment

by:AFouad
ID: 10866302
Ok Mohd.

- Old version of CA400 requires a fix of two files called BIDION.ini and BIDIOFF.ini to enable BI Directional retreival of data ... anyway if you can transfer correct data from AS400 using ordinary CA transfer you should not care about this anymore

- All projects that I have implemented with ISeries and VB were more easy than you described so let me check about our settings on the ISeries (cause we use Arabic also) and I will get back to you shortly.

- At the mean time have a look at
             http://www2.asna.com/datagateinfo.asp
  It's a usefull tool but only trial
0
 

Expert Comment

by:AFouad
ID: 10866366
Hi Mohd.

- QCCSID     = 65535
- QCHRID     = 337 & Code Page = 37
- QCCSID for user = 65535
- QCCSID for file   = 65535

Try this (if Possible)

Regards
AFouad
0
 
LVL 33

Accepted Solution

by:
shalomc earned 200 total points
ID: 10867207
Fouad,
When we couldn't get hebrew via ODBC, it turned out that the file code page was 65535.
When the file code page was changed to 424, the conversion took place.

I suggest that you change the file CCSID to 420 and retry the operation.
Then, there is the matter of right-to-left text direction....
With JDBC there should be no problem, with ODBC we have to see what happens.

ShalomC

0
 

Author Comment

by:Mohd_Farooqui
ID: 10877228
Thanks very much guys,

I am not in the office these days ,i will try all these settings and
let you know once i will be back in the office.

Thanks again
0
 

Expert Comment

by:hashmatjamal
ID: 11481971
Hello,

we r using iseries 810 with V5R2 , having problem in arabic printing on Lasers and Deskjet printers,
its printing only on printers having arabic fonts .

as one thing we upgrade to V5R2 from 4R4 and in 4R4 it was working fine

so can anyone help us in this issue

second thing

HTTP server
=======

HTTP server cant start if CCID page code 420 in use , we hav to change it thn it starts the HTTP server so anyone any idea how to fix it


Thanks

Hashmat Jamal
*** email address removed by Netminder, Site Admin ***
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With the evolution of technology, we have finally reached a point where it is possible to have home automation features like having your thermostat turn up and door lock itself when you leave, as well as a complete home security system. This is a st…
WooCommerce is becoming the most powerful e-commerce plugin for Wordpress. And why not. The platform comprises of numerous core plugins that may come in handy, powerful options to make your website development task much easier.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Suggested Courses

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question