Salman,

Can you tell us a little bit about your configuration? Oracle version platform etc. It would also be good to know the version of SQLNet/Net8 that is running on the workstations... look at one that is working and another that is not.

As far as I can tell, there are two possiblities

1. Some clients have had the Oracle client installed with the incorrect client character set, and the text is not being translated correctly. If this is the case, check the client character set on the workstations (the NLS_LANG setting).

2. Compare the regional language options on the workstations. Compare those that work to those that do not work. It is possible that those that have the problem, do not have the language support files that they need.


Regards

Macer

>The code is as follows, the problem description follows it
>
>Conn = "Provider=MSDAORA.1;Password=" + dpassword + ";User ID=" + duserid + ";Data Source=" + datasource + ";Persist Security Info=True"
> Screen.MousePointer = vbHourglass
>
> With db
> .ConnectionString = Conn
> .CursorLocation = adUseClient
>
> .Open
> .BeginTrans
> Screen.MousePointer = vbDefault
>
> End With
>
>
>Set rs = New Recordset
>
>
>
>sql = "SELECT project_code FROM project where project_id = '" & rs.Fields(0) & "' "
>rs.Close
>rs.Open sql, db, adOpenForwardOnly, adLockPessimistic
>getProjectCode = rs.Fields(0)
>
>____________________________________________________
>
>objective: rs.fields(0) should contain japanese script from the project_code field. it is confirmed that the field is coorect and the japanese data is in the field
>
>
>Now what happens is that on some machines rs.fields(0) gives correct japanese phrase but on some machines a constant japanese character is displayed for every character in the phrase for example if phrase is abcd in japanese then i see yyyy in the rs.fields(0). This happens on some machines only.
>
>quick help will be appreciated
>
>regards
>
>salman