Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Is it supported Korean language on ADS?

2 posts in OLEDB Last posting was on 2009-09-28 07:31:08.0Z
in-nam Hwang Posted on 2009-09-28 02:34:06.0Z
Reply-To: "in-nam Hwang" <inam@dataworks.co.kr>
From: "in-nam Hwang" <inam@dataworks.co.kr>
Newsgroups: advantage.oledb
Subject: Is it supported Korean language on ADS?
Date: Mon, 28 Sep 2009 11:34:06 +0900
Lines: 2464
Organization: datawroks
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 124.56.93.92
Message-ID: <4ac02050@solutions.advantagedatabase.com>
X-Trace: 27 Sep 2009 20:32:48 -0700, 124.56.93.92
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!124.56.93.92
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1322
Article PK: 1133841

Hi there.

I am testing ASP program(MS) with Korean datasets on Advantage Database
Server(9.1) with OLE DB provider.

provider connection string;
Provider=Advantage OLE DB Provider;User ID=adssys;Password=;Data
Source=D:\ads\TESTDB1.ADD;Advantage Server Type=ADS_REMOTE_SERVER;

Insert statement with Korean data;
ex)
INSERT INTO BOARD (title) VALUES('test') [ok]
INSERT INTO BOARD (title) VALUES('??????') [Error]

Error;
Advantage OLE DB Provider (0x80040E14)
Error 7200: AQE Error: State = 42000; NativeError = 2113; [iAnywhere
Solutions][Advantage SQL Engine]Unexpected end of SQL statement Insert into
BOARD (title) VALUES('??????')
/euc.asp, line 20


So, I am wondering whether ADS is supporting double bytes charecter
sets(Korean) with OLE DB provider?

Advantage Data Architect was good working for above SQLs (including Korean
data), but ASP was not working.
In SQL utility
Insert, Update, Select : ok
In ASP with OLE
Select : ok
insert, update : failed

attached file: Advantage configuration Utility

Thanks in advance,
In-Nam, Hwang

setinfo_installationInfo.JPG
setinfo_language.JPG

Joachim Duerr (ADS) Posted on 2009-09-28 07:31:08.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Is it supported Korean language on ADS?
Newsgroups: Advantage.OLEDB
References: <4ac02050@solutions.advantagedatabase.com>
Date: Mon, 28 Sep 2009 09:31:08 +0200
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 10.56.66.155
Message-ID: <4ac065e5@solutions.advantagedatabase.com>
X-Trace: 28 Sep 2009 01:29:41 -0700, 10.56.66.155
Lines: 19
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.56.66.155
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1323
Article PK: 1133842


in-nam Hwang wrote:

>Insert statement with Korean data;
>ex)
>INSERT INTO BOARD (title) VALUES('test') [ok]
>INSERT INTO BOARD (title) VALUES('??????') [Error]
>
>Error;
>Advantage OLE DB Provider (0x80040E14)
>Error 7200: AQE Error: State = 42000; NativeError = 2113; [iAnywhere
>Solutions][Advantage SQL Engine]Unexpected end of SQL statement
>Insert into BOARD (title) VALUES('??????') /euc.asp, line 20

answered in Advantage.General....please don't xpost.

--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch