Charset conversion problem in sybase through ADO-ASP

[Lutfal]

Hi,

I get following error (in some cases pointed below) while inserting data into a text field in a sybase database table through ADO and ASP 3.0.

############## ERROR ######
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[INTERSOLV][ODBC SQL Server driver][SQL Server]Error converting client characters into server's character set. Some character(s) could not be converted.

#############

Here are some points that may be of help ...

1. I am inserting data which contains Characters with ASCII value more than 150 (in fact it is in Norweigan Language)

2. I do not face this type of problem when data is in normal english language.

3. Surprisingly while inserting through ISQL from the same machine we dont get this error. But we need to insert data through ADO only and let the application(webpage.. asp page) user to insert data and update

4. The same data can easily be inserted in MySQL table or
MS-SQL 7.0 table field. No problem faced.

5. The sybase is installed in a win2k server with IIS 5 and ADO 3.0. I am inserting data through ODBC-ADO connection

..Is there any place in the Sybase admin or IIS admin or option in the insert command (Right now I am just using Normal Insert and update statement)

#######
con.execute ("insert into Prod_desc (id, prod_desc) values('"&prod_id&"','"&prod_desc&"' )&quot

con.execute ("update Products set prod_desc='"&prod_desc&"' where...&quot

where con is the ODBC connection object

#######

Any help will be appreciated.

Lutfal