ODBC install and extended ascii

[NewsArchive]

Hi you'll.

I have a probleme which "might" be related to installation, I am not sure,
but I thought I will ask here, as maybe some have an wexperience with that.

I have a PostgreSQL database of french data, with accented letters in
many columns. Everything was displaying properly in my Clarion program as
long as I was in dev mode. This week-end I made an install program (using
Sb5), and I guess I changed "something" in the ODBC settings, but
now accented letters are replaced by a Question mark. Tested in Excel, same
thing. Checking with PgAdmin to see the data, eveything is normal there,
but PgAdmin do not use ODBC. So it seems ODBC is the guilty one, here, the
only problem is that I have no ideas where to look for.

If it was not for those damn accented letters, the install works perfectly,
copying the ODBC driver and setting it up, then opening the dialog box for
user parameters

Anyone with a clue? Maybe I should add that the original ODBC driver
install from Postgres use MSI. Should I include this install into mine
instead?

Thanks,
Bernard

[NewsArchive]

Bernard,

Does your SQL Server driver requires the server name and a flag for OEM to
ANSI conversion?

Thanks,
Friedrich

--
Friedrich Linder
CEO, Lindersoft
www.lindersoft.com
1.954.252.3910

[NewsArchive]

Friedrich,

> Does your SQL Server driver requires the server name and a flag for OEM to
> ANSI conversion?

For the server name, yes, I am sure. For a OEM to Ansi flag, I don't know.
I don't see that in the setup options, but maybe I am looking in the wrong
place ?

Bernard.

[NewsArchive]

Bernard,

I don't have experiences with PostgreSQL, but I think you have to set a
translation DLL (see your ODBC manual).

Something like the following in your "Data Source Attributes" (Config ODBC
Data Sources script function):

TranslationDLL=path of the translation DLL
TranslationOption=see ODBC manual

Does this help?

Friedrich

--
Friedrich Linder
CEO, Lindersoft
www.lindersoft.com
1.954.252.3910

[NewsArchive]

Should read:

"...Something like the following in your "Data Source Attributes" (Install
ODBC Driver Data Sources script function):..."

--
Friedrich Linder
CEO, Lindersoft
www.lindersoft.com
1.954.252.3910