ODBC returns error

[dickiebird]

Guys....
I'm to this forum - so if its been asked before - I didn't know ( and couldn't find it)
We run a MSAccess2 process on Windows 2000, which refers to Sybase tables for a report via a form.
Unfortunately, we have non-Engish characters on the table
(addresses) which ODBC can't interpret. The error returned is the Sybase generated error 2204 where unknown characters are supposed to be set to a question-mark(?).
Is there some setting required on the PC to avoid this failure?
TIA

Dickie Bird (-)))

 

[Ed2020]

Do you really mean Access 2?

Or should that have read Access2K?

Ed Metcalfe.

Please do not feed the trolls.....

 

[dickiebird]

I know, I know - how could anyone still be using Access2 !
Well - we are - it's got some embedded DDE ( does some screen scraping of Rumba ) and no-one wants(dares) to be responsible for updgrading it !
I notice that in the ODBC setup - the character set translators don't include OEM to ANSI - could this be a possbility ? Where are the translator dll's saved ?
Thanks

Dickie Bird (-)))

 

[Ed2020]

dickiebird,

To be honest, I've no idea. I'm not even sure I could get hold of a copy of Access 2 to check for you!

Sorry I can't be of much more help. I can highly recommend converting to a newer version of Access though - it really shouldn't be too much of a job....

Ed Metcalfe.

Please do not feed the trolls.....

 

[dickiebird]

Thanks for looking.
I'm no Access programmer, so it won't be me that ever upgrades the process.
I found all the 'foreign' characters on the db table, and replaced them ( Only 55 to do ) - so now there's no error !

Dickie Bird (-)))