By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

SQL30020 on extended ascii characters

P: n/a

we have a legacy application written in C. It uses embedded sql to
connect to the database and to perform queries on it. Now we are
writing several extensions in .net, and it would be necessary to use
the same connection instance as the embedded sql because of
transactions. So I open the database connection in .net (Odbc, OleDb
and ibm .net data provider was also tried), and the embedded sql
queries can use it. However, when a parameter in the embedded sql
query contains extended ascii characters (e.g , , etc.), I get the
following error: SQL30020N Execution of the command or SQL statement
failed because of a syntax error in the communication data stream that
will affect the successful execution.... Reason Code:0x220E,
SQLSTATE=58009. In the legacy application we use single-byte
characters to store strings exclusively. The codepage is 1250 on both
the client computer and the database. We use DB2, the OS
is Vista (XPSP2 was also tried)


Oct 12 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.