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.

Problem while using VB6 and ASA 8.0.2.3601

2 posts in General Discussion Last posting was on 2003-03-31 14:59:33.0Z
Jack Posted on 2003-03-31 07:11:19.0Z
From: "Jack" <sz_byk@163.com>
Subject: Problem while using VB6 and ASA 8.0.2.3601
Date: Mon, 31 Mar 2003 15:11:19 +0800
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Message-ID: <uqzS$S19CHA.267@forums-1-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 218.18.48.77
Path: forums-1-dub!forums-master.sybase.com!forums-1-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:852
Article PK: 4015

My problem is : Chinese data inert by VB program can not be show properly in
Utralite db when the data was synchronized between ASA and Utralite DB.

The ASA version is 8.0.2.3601.

*I created a asa DB use the command:dbinit -n -z utf8
F:\files\vb\testInformix\db\cm.db.(then use Sybase Central to add some
table in it )

*The Utralite DB I create by the command:
ulinit -c "uid=dba;pwd=sql;filedsn=F:\files\vb\testInformix\db\cm.dsn" -f
cm.usm -n *

*dbeng parameter used in dsn file :
Start=d:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe -c 8m

*dbmlsrv8 parameters:
start /min dbmlsrv8.exe -v -vr -vs -o custdbsrv.log -c
"filedsn=F:\files\vb\testInformix\db\cm.dsn"

I want to get records from an Informix DB ,then insert them into ASA DB(by a
VB program),then synchronize the Utralite DB(used in PDA) with the ASA DB by
ML

(I have developed a project use EVB and Utralite DB successfully,which
insert data by PDA and then synchronize with ASA DB)
I have implemented the flows successfully.
But the data contained Chinese in ASA DB contain some unexpected addition
code(the addition code seem to be added by VB6 program,which made the data
can be view properly in Sybase Central but can not be showed properly in
Utralite DB)

in Sybase ISQL use the SQL command:

update comp_base_info set comp_name='ÄãºÃ'+comp_name+'ÄãºÃ'

then ,the new addition data 'ÄãºÃ' can not be showed properly(became chaos
code) but the
Chinese 'comp_name' data can be showed properly as before.
The experiment show that the data inert by VB6 program contained some
unexpected code.


Reg Domaratzki Posted on 2003-03-31 14:59:33.0Z
From: "Reg Domaratzki" <rdomarat__AT__sybase__DOT__com>
References: <uqzS$S19CHA.267@forums-1-dub>
Subject: Re: Problem while using VB6 and ASA 8.0.2.3601
Date: Mon, 31 Mar 2003 09:59:33 -0500
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <#lT3Gb59CHA.334@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rdomarat-pc.sybase.com 172.31.143.163
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:853
Article PK: 2768

Please don't cross post. This question was best asked on the UltraLite
newsgroup, where someone has responded to your post already.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Jack" <sz_byk@163.com> wrote in message
news:uqzS$S19CHA.267@forums-1-dub...
> My problem is : Chinese data inert by VB program can not be show properly
in
> Utralite db when the data was synchronized between ASA and Utralite DB.
>
> The ASA version is 8.0.2.3601.
>
> *I created a asa DB use the command:dbinit -n -z utf8
> F:\files\vb\testInformix\db\cm.db.(then use Sybase Central to add some
> table in it )
>
> *The Utralite DB I create by the command:
> ulinit -c "uid=dba;pwd=sql;filedsn=F:\files\vb\testInformix\db\cm.dsn" -f
> cm.usm -n *
>
> *dbeng parameter used in dsn file :
> Start=d:\Program Files\Sybase\SQL Anywhere 8\win32\dbeng8.exe -c 8m
>
> *dbmlsrv8 parameters:
> start /min dbmlsrv8.exe -v -vr -vs -o custdbsrv.log -c
> "filedsn=F:\files\vb\testInformix\db\cm.dsn"
>
> I want to get records from an Informix DB ,then insert them into ASA DB(by
a
> VB program),then synchronize the Utralite DB(used in PDA) with the ASA DB
by
> ML
>
> (I have developed a project use EVB and Utralite DB successfully,which
> insert data by PDA and then synchronize with ASA DB)
> I have implemented the flows successfully.
> But the data contained Chinese in ASA DB contain some unexpected addition
> code(the addition code seem to be added by VB6 program,which made the data
> can be view properly in Sybase Central but can not be showed properly in
> Utralite DB)
>
> in Sybase ISQL use the SQL command:
>
> update comp_base_info set comp_name='ÄãºÃ'+comp_name+'ÄãºÃ'
>
> then ,the new addition data 'ÄãºÃ' can not be showed properly(became chaos
> code) but the
> Chinese 'comp_name' data can be showed properly as before.
> The experiment show that the data inert by VB6 program contained some
> unexpected code.
>
>
>
>
>