Conference orarep::nomahs::odbc_rdb_driver

    Looking at the Microsoft documentation and the Oracle7 ODBC driver, it
    seems that what the customer needs is a .DLL for doing the
    translation. Where would he get one from?
    
    The Oracle7 ODBC driver seems to use the dialogue box supplied by ODBC
    2.0 for selecting a translator. Will the ODBC driver for Rdb be changed
    to use this (SQLGetTranslator)? Should I enter a BUG to request this?
    
    Peter

    It seems that they need the Microsoft Code Page Translator. Is this
    suppplied with the Rdb Odbc driver? It does seem to be with the Oracle7
    one, so the customer could try copying that off the web. There are
    several options for it. One seems to do the translation from ISO Latin2
    that they want. What option number is this?
    
    Peter

Hey Peter - (or anyone else),

Your customer apparently didn't like your answer or before you gave to them
they posted the same question in our supportlink page.  Since some kind of
reply needs to be made, have you found out anything more?

>    It seems that they need the Microsoft Code Page Translator.
how did you figure this out?
what is the name of the this dll?
did you find out what the option number is?

FWIW: i did a search across all files looking for isolatin2, found 1 dll
containing it, so..  put in c:\window\system\what_ever_it_was in a
datasource and fire it off.  immediately got odbc call failed
[oracle][odbc]unable to load translation dll (#0)

so we try or the other stuff that MS supplies is trying?
who knows, is it us or them trying?

    
Jerry

>Your customer apparently didn't like your answer or before you gave to them
>they posted the same question in our supportlink page.  Since some kind of
>reply needs to be made, have you found out anything more?
         
    I've not actually spoken to the customer, just to Oracle Czech support.
    I haven't found anything more. I was planning to BUG this today.
    
>>    It seems that they need the Microsoft Code Page Translator.
>how did you figure this out?
    
    I spoke to someone who does Oracle7 ODBC support. When configuring a
    dataset yopu can bring up a dialogue box for selecting a translator.
    The only options where none or the Microsoft Code Page Translator. If
    you select it you are given a list of options to choose from. One seems
    to be the one wanted. A picture of the dialogue box appears in the ODBC
    Technical Reference manual.
    
>what is the name of the this dll?
    
    MSCPXL32.DLL
    
>did you find out what the option number is?
    
    No.

>so we try or the other stuff that MS supplies is trying?
>who knows, is it us or them trying?
    
    Since the dialogue box appears in the Microsoft manual, and the .DLL
    name begins with MS, it looks like they supply it. However, I guess
    that we should ship it with our driver.
    
    Peter
    

    So, Peter, do you know what the answer is for option and library.  I
    need to provide a response in MetaLink Forum for this.  I guess the
    .dll mention in an earlier response would be the answer for the
    library.  How about the number for the option?
    
    Thanks,
    
    

    Sorry, I don't know the option number. I will chase the bug.
    
    Peter

    It looks like the question in the MetaLink Forum came from the same source
    as my TAR. I.e. Czech Rdb support.
    
    Peter

    I received this message today.

    I have already found the solution of this problem.
The "Translation Library" is

    c:\windows\system\mscpxl32.dll

and the "Translation Option" is for instance

    12500859.cpx

It is the name of a file stored in the same directory as the translation
library and this file defines the conversion table between two national
character sets. I have not found this file for ISO Latin-2 and MS Windows
Latin-2 character sets, but it was not very difficult to create it. The
naming convention used for this file is the number of code page 1 (1250)
and the number of code page 2 (0859) and an extension ".cpx"
   
   Peter