I connect to ASE 12.5 database using a connect string without having to set up a DSN using the ODBC administrator.

My connecstring = "Driver={Sybase ASE ODBC Driver};Uid=sa;Pws=Password;Srvr=servername;NL=Win sock;Translate=OEM to ANSI"

The connection is succeded, I would like to display the data with french set characters, but i cannot have the possibilites to use the translator OEM to ANSI(in the DSN file, we can use the translator)

Thanks for any help.