SQL Anywhere Mobile - mobilink from ASA to ASE

Author

mobilink from ASA to ASE

Sunshine

2005-11-01, 7:23 am

Hi Guys

I want to develop an mobilink application,in which ASA as remote db and ASE
as consolidated db.
There is a lage table in consolidated database from which I want to download
some data.
When I write download_cusor event script as follows: "select * from
tablename where columename like '123%'",the synchronization runs well.I get
8 rows in remote database.
But when I write download_cusor script event as those: "select * from
tablename where columename like '1%'",there should get hundreds of rows.
mobilink server is report as "from MobiLink server's SQLCode is -10002" and
"ODBC: [DataDirect][ODBC Sybase Wire Protocol
driver]String data code page conversion failed. Error in column 17.£¨ODBC
status = HY000£¬local error code = 0£¬column or parm #17£©".
so I modified script as "select * from tablename where columename like
'123%'" again, it run well and get correct result.
I pay attention that in the first download procedure the client get a 1453
bytes stream from mobilink server.But the second I only get a 145 bytes from
it. So I think mobilink server donnot get the correct data from consolidated
database server, am I right?
I check my odbc config and I using "ianywhere solution - ase".
So could anyone give me some suggestion?
Many thanks for you kindly help!

Chris Keating(iAnywhere Solutions)

2005-11-01, 9:23 am

There is something more fundamental here. If you look at the error
"String data code page conversion failed", it appears that there is a
problem with translation of data so one of the rows of the expanded
result set has some sort of problem. The question now is how to
determine the problem row and then determine how to correct the problem.

Can you run your ML server with the -v+ and -o <filename> to capture
what is being processed by ML at the time of this error.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

********************
********************
********************
*****************

Chris Keating(iAnywhere Solutions)

2005-11-01, 9:23 am

Can you also provide the version and builds for both the ASA and ASE
environment.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

********************
********************
********************
*****************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

********************
********************
********************
*****************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

********************
********************
********************
*****************

Greg Fenton

2005-11-01, 9:23 am

Sunshine wrote:
> When I write download_cusor event script as follows: "select * from
> tablename where columename like '123%'"

As a side note to Chris's response, we *strongly* discourage the use of
"SELECT *" in synchronization scripts. If you ever have a need to
modify the schema in your consolidated, you will break synchronization.

In fact, in my opinion, there is *never* a reason to use "SELECT *" in
source code. Any place that you code like this becomes a maintenance
headache down the road. As you are writing the code, you know which
columns you want to retrieve, so code those columns.

[Note: there is a very rare category of applications where "SELECT *"
does make sense...but they are so rare that if you are writing on of
those applications then you alread know this ;-) ]

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sunshine

2005-11-01, 8:48 pm

My ASA version is 9.0.2 and ASE is 12.5.2
"Chris Keating(iAnywhere Solutions)"
< NoSpamPlease_k_e_a_t
_i_n_g@i_A_n_y_w_h_e
_r_e.com>
??????:43676ed2$1@forums-1-dub...
> There is something more fundamental here. If you look at the error "String
> data code page conversion failed", it appears that there is a problem with
> translation of data so one of the rows of the expanded result set has some
> sort of problem. The question now is how to determine the problem row and
> then determine how to correct the problem.
>
> Can you run your ML server with the -v+ and -o <filename> to capture what
> is being processed by ML at the time of this error.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> ********************
********************
********************
*****************
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> ********************
********************
********************
*****************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
> ********************
********************
********************
*****************

Sunshine

2005-11-02, 3:24 am

Is there any differences between ASA developer Edition and Formal Edition?
I uses asa 9.0.2 developer edition downloaded from www.sybase.com.
Thanks!
"Chris Keating(iAnywhere Solutions)"
< NoSpamPlease_k_e_a_t
_i_n_g@i_A_n_y_w_h_e
_r_e.com>
??????:43676ed2$1@forums-1-dub...
> There is something more fundamental here. If you look at the error "String
> data code page conversion failed", it appears that there is a problem with
> translation of data so one of the rows of the expanded result set has some
> sort of problem. The question now is how to determine the problem row and
> then determine how to correct the problem.
>
> Can you run your ML server with the -v+ and -o <filename> to capture what
> is being processed by ML at the time of this error.
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> ********************
********************
********************
*****************
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> ********************
********************
********************
*****************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
> ********************
********************
********************
*****************

Greg Fenton

2005-11-03, 8:29 pm

Sunshine wrote:
> Is there any differences between ASA developer Edition and Formal Edition?
> I uses asa 9.0.2 developer edition downloaded from www.sybase.com.

Nothing different that would lead to the issues you are seeing. The
binaries are essentially the same, the main difference is the appearance
of the splash screen (and a few missing features such as communication
encryption).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links