Home > Archive > SQL Anywhere Mobile > April 2005 > Starting with Mobilink









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Starting with Mobilink
CC

2005-04-12, 7:24 am

Excuse my ignorance with Mobilink. Today is my first day with it. Excuse
also my english level. This comes from Spain.

I´m trying to run samples included in c:\...\Sybase\SQL Anywhere
9\Samples\MobiLink\
but gives me this error:

E. 12/04 11:43:41. <Principal>: Error: [-10002] ODBC:
[Microsoft][Administ
rador de controladores ODBC] No se encuentra el nombre
del origen de datos y no se especificó ningún controlador predeterminado
(Estado de ODBC = IM002, Código de error nativo = 0)

What i´m doing wrong ??. Many thanks:

Natalia


Reg Domaratzki \(iAnywhere Solutions\)

2005-04-12, 9:24 am

I'm pretty sure this translates to "Data source name not found and no
default driver specified".

Which sample are you running? All the samples I looked at use the dbdsn
command to define the DSN used by the sample before it is needed. Can you
describe the steps you took when running the sample?

--
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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"CC" <softQUITAESTO@gic.es> wrote in message news:425b9908@forums
-2-dub...
> Excuse my ignorance with Mobilink. Today is my first day with it. Excuse
> also my english level. This comes from Spain.
>
> I´m trying to run samples included in c:\...\Sybase\SQL Anywhere
> 9\Samples\MobiLink\
> but gives me this error:
>
> E. 12/04 11:43:41. <Principal>: Error: [-10002] ODBC:
> [Microsoft][Administ
rador de controladores ODBC] No se encuentra el nombre
> del origen de datos y no se especificó ningún controlador predeterminado
> (Estado de ODBC = IM002, Código de error nativo = 0)
>
> What i´m doing wrong ??. Many thanks:
>
> Natalia
>
>


CC

2005-04-12, 1:24 pm

Hi Reg. Thanks for your help. I´m trying now to follow this tutorial:

http://download.sybase.com/pdfdocs/awg0902e/dbmten9.pdf

and the problem is when i try to start the Mobilink syncronization server
(pag. 18).

It gives me a problem with tables for syncronitzacion in consolidated
database:

E. 12/04 18:58:47. <Principal>: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]Column not found: Column 'last_upload_time'
not found (Estado de ODBC = 42S22, Código de error nativo = -143)
E. 12/04 18:58:47. <Principal>: Error: Falta la columna 'last_upload_time'
de la tabla 'ml_user' del sistema MobiLink
I. 12/04 18:58:48. <Principal>: Desconectado
I. 12/04 18:58:48. <Principal>: El servidor MobiLink ha finalizado

Why when i create a database, asa doen´t add syncronitzacion tables. How can
i create this for an existing database.

I`m using Adaptive Server Anywhere 8 8.0.1.2600. Is this the problem ??. Is
there a more recent asa version ?? Where can i achieve it ??

Excuse my ignorance. Many anticipated thanks:

Natalia





"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
escribió en el mensaje news:425bc7c3$1@foru
ms-1-dub...
> I'm pretty sure this translates to "Data source name not found and no
> default driver specified".
>
> Which sample are you running? All the samples I looked at use the dbdsn
> command to define the DSN used by the sample before it is needed. Can you
> describe the steps you took when running the sample?
>
> --
> 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
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "CC" <softQUITAESTO@gic.es> wrote in message news:425b9908@forums
-2-dub...
nombre[color=darkred
]
>
>


Reg Domaratzki \(iAnywhere Solutions\)

2005-04-12, 1:24 pm

The error you describe in this post is definitely because you are using a
v90 MobiLink Server against a v801 database. The MobiLink system tables
created in this older database are not compatible with the v902 MobiLink
server.

Do you have both ASA v801 and ASA v902 installed on the same machine?

--
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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"CC" <softQUITAESTO@gic.es> wrote in message news:425bff8c@forums
-2-dub...
> Hi Reg. Thanks for your help. I´m trying now to follow this tutorial:
>
> http://download.sybase.com/pdfdocs/awg0902e/dbmten9.pdf
>
> and the problem is when i try to start the Mobilink syncronization server
> (pag. 18).
>
> It gives me a problem with tables for syncronitzacion in consolidated
> database:
>
> E. 12/04 18:58:47. <Principal>: Error: [-10002] ODBC: [Sybase][ODBC
> Driver][Adaptive Server Anywhere]Column not found: Column
'last_upload_time'[c
olor=darkred]
> not found (Estado de ODBC = 42S22, Código de error nativo = -143)
> E. 12/04 18:58:47. <Principal>: Error: Falta la columna 'last_upload_time'
> de la tabla 'ml_user' del sistema MobiLink
> I. 12/04 18:58:48. <Principal>: Desconectado
> I. 12/04 18:58:48. <Principal>: El servidor MobiLink ha finalizado
>
> Why when i create a database, asa doen´t add syncronitzacion tables. How[/color]
can
> i create this for an existing database.
>
> I`m using Adaptive Server Anywhere 8 8.0.1.2600. Is this the problem ??.
Is
> there a more recent asa version ?? Where can i achieve it ??
>
> Excuse my ignorance. Many anticipated thanks:
>
> Natalia
>
>
>
>
>
> "Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
> escribió en el mensaje news:425bc7c3$1@foru
ms-1-dub...
you[color=darkred]
> http://www.ianywhere.com/developer/product_manuals
news:425b9908@forums
-2-dub...[color=darkred]
Excuse[color=darkred
]
> nombre
predeterminado[color
=darkred]
>
>


David Fishburn

2005-04-13, 9:24 am

"CC" <softQUITAESTO@gic.es> wrote in news:425b9908@forums
-2-dub of
sybase.public.sqlanywhere.mobilink:

C> E. 12/04 11:43:41. <Principal>: Error: [-10002] ODBC:
C> [Microsoft][Administ
rador de controladores ODBC] No se encuentra el
C> nombre del origen de datos y no se especificó ningún controlador
C> predeterminado (Estado de ODBC = IM002, Código de error nativo = 0)

Since most of us are native english speakers, could you translate the
messages to english for us, it will help us answer your questions.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

CC

2005-04-13, 8:24 pm

Hi Reg. Many thanks for your answer.

I´ve both ASA 8 and ASA 9 installed in my computer.

Today i´ve reinstalled SQL Anywhere 9. All now is version 9. It seems that
work, but when i try to start the Mobilink syncronization server
(pag. 18) with:
dbmlsrv9 -c "dsn=test_consol" -o mlserver.mls -v+ -dl -za -zu+

, it gives me this error:


E. 04/13 20:46:15. <Main>: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]Column 'last_upload_time' not found (ODBC
State = 42S22, Native error code = -143)
E. 04/13 20:46:15. <Main>: Error: The MobiLink system table 'ml_user' is
missing column 'last_upload_time'
I. 04/13 20:46:15. <Main>: Disconnected
I. 04/13 20:46:15. <Main>: MobiLink server finished


With Interactive SQL, i can see that this table, and this column exists.

What´s wrong ???????????

Many thanks:

Natalia


COMPLET SECUENCE MOBILINK
-----------------------------------------


I. 04/13 20:46:11. Adaptive Server Anywhere MobiLink Version 9.0.2.2451
I. 04/13 20:46:11.
I. 04/13 20:46:11. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 04/13 20:46:11. All rights reserved. All unpublished rights reserved.
I. 04/13 20:46:11.
I. 04/13 20:46:11. This software contains confidential and trade secret
information of
I. 04/13 20:46:11. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 04/13 20:46:11. by the U.S. Government is subject to restrictions set
forth in a license
I. 04/13 20:46:11. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 04/13 20:46:11. other written agreement specifying the Government's
rights to use the
I. 04/13 20:46:11. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 04/13 20:46:11.
I. 04/13 20:46:11. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 04/13 20:46:11.
I. 04/13 20:46:11. Networked Seat (per-seat) model. Access to the server is
limited to 1 seat(s).
This server is licensed to:
I. 04/13 20:46:11. Developer Edition
I. 04/13 20:46:11. Restricted Use
I. 04/13 20:46:14. <Main>: MobiLink server started
I. 04/13 20:46:14. <Main>: Option 1: -c
I. 04/13 20:46:14. <Main>: Option 2: dsn=test_consol
I. 04/13 20:46:14. <Main>: Option 3: -v+
I. 04/13 20:46:14. <Main>: Option 4: -za
I. 04/13 20:46:14. <Main>: Option 5: -zu+
I. 04/13 20:46:14. <Main>: Verbose logging: show row values
I. 04/13 20:46:14. <Main>: Verbose logging: show script names when invoked
I. 04/13 20:46:14. <Main>: Verbose logging: show script contents when
invoked
I. 04/13 20:46:14. <Main>: Verbose logging: show schema for each table
I. 04/13 20:46:14. <Main>: Verbose logging: show an error when the first
read of a synchronization fails
I. 04/13 20:46:14. <Main>: Verbose logging: show translated SQL for prepared
statements
I. 04/13 20:46:14. <Main>: Verbose logging: show rowcount values
I. 04/13 20:46:14. <Main>: Individual database connections will be closed
after synchronization errors.
I. 04/13 20:46:14. <Main>: BLOB cache size: 524288
I. 04/13 20:46:14. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 04/13 20:46:14. <Main>: Maximum number of database connections: 6
I. 04/13 20:46:14. <Main>: Maximum number of deadlock retries: 10
I. 04/13 20:46:14. <Main>: Timeout for inactive database connections: 60
minutes
I. 04/13 20:46:14. <Main>: Maximum delay between retries after deadlock: 30
seconds
I. 04/13 20:46:14. <Main>: Rowset size: 10
I. 04/13 20:46:14. <Main>: Upload cache size: 524288 bytes
I. 04/13 20:46:14. <Main>: Download cache memory size: 1048576 bytes
I. 04/13 20:46:14. <Main>: Download cache directory size: 10485760 bytes
I. 04/13 20:46:14. <Main>: Number of worker threads: 5
I. 04/13 20:46:14. <Main>: Maximum number of threads uploading concurrently:
5
W. 04/13 20:46:14. <Main>: Warning: Unknown users will be added
automatically (when there is no authenticate_user script).
I. 04/13 20:46:14. <Main>: Warning: Example scripts may be automatically
generated and activated for unknown versions.
I. 04/13 20:46:14. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 04/13 20:46:14. <Main>: Stream specifier 1: TCPIP
I. 04/13 20:46:15. <Main>: ODBC DBMS Name: Adaptive Server Anywhere
I. 04/13 20:46:15. <Main>: ODBC DBMS Version: 09.00.0002
I. 04/13 20:46:15. <Main>: ODBC DBMS Driver Version: 09.00.0002
I. 04/13 20:46:15. <Main>: ODBC Version supported by the driver: 3.52
I. 04/13 20:46:15. <Main>: Collation sequence of the consolidated database
is 'cp1252'
I. 04/13 20:46:15. <Main>: Translated SQL:
set temporary option chained = 'ON'
I. 04/13 20:46:15. <Main>: ODBC isolation set to: Read Committed
I. 04/13 20:46:15. <Main>: Connected
E. 04/13 20:46:15. <Main>: Error: [-10002] ODBC: [Sybase][ODBC
Driver][Adaptive Server Anywhere]Column 'last_upload_time' not found (ODBC
State = 42S22, Native error code = -143)
E. 04/13 20:46:15. <Main>: Error: The MobiLink system table 'ml_user' is
missing column 'last_upload_time'
I. 04/13 20:46:15. <Main>: Disconnected
I. 04/13 20:46:15. <Main>: MobiLink server finished






















"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
escribió en el mensaje news:425c01dd$1@foru
ms-2-dub...
> The error you describe in this post is definitely because you are using a
> v90 MobiLink Server against a v801 database. The MobiLink system tables
> created in this older database are not compatible with the v902 MobiLink
> server.
>
> Do you have both ASA v801 and ASA v902 installed on the same machine?
>
> --
> 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
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "CC" <softQUITAESTO@gic.es> wrote in message news:425bff8c@forums
-2-dub...
server[color=darkred
]
> 'last_upload_time'
'last_upload_time'[c
olor=darkred]
> can
> Is
dbdsn[color=darkred]

> you
> news:425b9908@forums
-2-dub...
> Excuse
> predeterminado
>
>


Reg Domaratzki \(iAnywhere Solutions\)

2005-04-13, 8:24 pm

This means that the underlying database that you are using is still a v8
database. When you initialized your database in this tutorial by executing
"dbinit consol.db", what version of dbinit were you using? It should be the
first line that dbinit outputs to the console.

[90][d:\temp]dbinit consol.db
Adaptive Server Anywhere Initialization Utility Version 9.0.2.3110
Creating system tables
Collation sequence: 1252LATIN1
Creating system views
Setting permissions on system tables and views
Setting option values
Initializing UltraLite deployment option
Database "consol.db" created successfully

I suspect that you have ASA v8 in your PATH first, and you are initializing
a v8 database, not a v9 database.

--
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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"CC" <softQUITAESTO@gic.es> wrote in message news:425d6afd@forums
-2-dub...
> Hi Reg. Many thanks for your answer.
>
> I´ve both ASA 8 and ASA 9 installed in my computer.
>
> Today i´ve reinstalled SQL Anywhere 9. All now is version 9. It seems that
> work, but when i try to start the Mobilink syncronization server
> (pag. 18) with:
> dbmlsrv9 -c "dsn=test_consol" -o mlserver.mls -v+ -dl -za -zu+
>
> , it gives me this error:
>
>
> E. 04/13 20:46:15. <Main>: Error: [-10002] ODBC: [Sybase][ODBC
> Driver][Adaptive Server Anywhere]Column 'last_upload_time' not found (ODBC
> State = 42S22, Native error code = -143)
> E. 04/13 20:46:15. <Main>: Error: The MobiLink system table 'ml_user' is
> missing column 'last_upload_time'
> I. 04/13 20:46:15. <Main>: Disconnected
> I. 04/13 20:46:15. <Main>: MobiLink server finished
>
>
> With Interactive SQL, i can see that this table, and this column exists.
>
> What´s wrong ???????????
>
> Many thanks:
>
> Natalia
>
>
> COMPLET SECUENCE MOBILINK
> -----------------------------------------
>
>
> I. 04/13 20:46:11. Adaptive Server Anywhere MobiLink Version 9.0.2.2451
> I. 04/13 20:46:11.
> I. 04/13 20:46:11. Copyright © 1989-2004 Sybase, Inc.
> Portions Copyright © 2002-2004, iAnywhere Solutions,
Inc.
> I. 04/13 20:46:11. All rights reserved. All unpublished rights reserved.
> I. 04/13 20:46:11.
> I. 04/13 20:46:11. This software contains confidential and trade secret
> information of
> I. 04/13 20:46:11. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the software and
> documentation
> I. 04/13 20:46:11. by the U.S. Government is subject to restrictions set
> forth in a license
> I. 04/13 20:46:11. agreement between the Government and iAnywhere
Solutions,
> Inc. or
> I. 04/13 20:46:11. other written agreement specifying the Government's
> rights to use the
> I. 04/13 20:46:11. software and any applicable FAR provisions, for
example,
> FAR 52.227-19.
> I. 04/13 20:46:11.
> I. 04/13 20:46:11. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
> 94568, USA
> I. 04/13 20:46:11.
> I. 04/13 20:46:11. Networked Seat (per-seat) model. Access to the server
is
> limited to 1 seat(s).
> This server is licensed to:
> I. 04/13 20:46:11. Developer Edition
> I. 04/13 20:46:11. Restricted Use
> I. 04/13 20:46:14. <Main>: MobiLink server started
> I. 04/13 20:46:14. <Main>: Option 1: -c
> I. 04/13 20:46:14. <Main>: Option 2: dsn=test_consol
> I. 04/13 20:46:14. <Main>: Option 3: -v+
> I. 04/13 20:46:14. <Main>: Option 4: -za
> I. 04/13 20:46:14. <Main>: Option 5: -zu+
> I. 04/13 20:46:14. <Main>: Verbose logging: show row values
> I. 04/13 20:46:14. <Main>: Verbose logging: show script names when invoked
> I. 04/13 20:46:14. <Main>: Verbose logging: show script contents when
> invoked
> I. 04/13 20:46:14. <Main>: Verbose logging: show schema for each table
> I. 04/13 20:46:14. <Main>: Verbose logging: show an error when the first
> read of a synchronization fails
> I. 04/13 20:46:14. <Main>: Verbose logging: show translated SQL for
prepared
> statements
> I. 04/13 20:46:14. <Main>: Verbose logging: show rowcount values
> I. 04/13 20:46:14. <Main>: Individual database connections will be closed
> after synchronization errors.
> I. 04/13 20:46:14. <Main>: BLOB cache size: 524288
> I. 04/13 20:46:14. <Main>: Maximum number of BLOB bytes to compare:
> 4294967295
> I. 04/13 20:46:14. <Main>: Maximum number of database connections: 6
> I. 04/13 20:46:14. <Main>: Maximum number of deadlock retries: 10
> I. 04/13 20:46:14. <Main>: Timeout for inactive database connections: 60
> minutes
> I. 04/13 20:46:14. <Main>: Maximum delay between retries after deadlock:
30
> seconds
> I. 04/13 20:46:14. <Main>: Rowset size: 10
> I. 04/13 20:46:14. <Main>: Upload cache size: 524288 bytes
> I. 04/13 20:46:14. <Main>: Download cache memory size: 1048576 bytes
> I. 04/13 20:46:14. <Main>: Download cache directory size: 10485760 bytes
> I. 04/13 20:46:14. <Main>: Number of worker threads: 5
> I. 04/13 20:46:14. <Main>: Maximum number of threads uploading
concurrently:
> 5
> W. 04/13 20:46:14. <Main>: Warning: Unknown users will be added
> automatically (when there is no authenticate_user script).
> I. 04/13 20:46:14. <Main>: Warning: Example scripts may be automatically
> generated and activated for unknown versions.
> I. 04/13 20:46:14. <Main>: Local file for remote synchronization logs:
> 'dbmlsrv.mle'
> I. 04/13 20:46:14. <Main>: Stream specifier 1: TCPIP
> I. 04/13 20:46:15. <Main>: ODBC DBMS Name: Adaptive Server Anywhere
> I. 04/13 20:46:15. <Main>: ODBC DBMS Version: 09.00.0002
> I. 04/13 20:46:15. <Main>: ODBC DBMS Driver Version: 09.00.0002
> I. 04/13 20:46:15. <Main>: ODBC Version supported by the driver: 3.52
> I. 04/13 20:46:15. <Main>: Collation sequence of the consolidated database
> is 'cp1252'
> I. 04/13 20:46:15. <Main>: Translated SQL:
> set temporary option chained = 'ON'
> I. 04/13 20:46:15. <Main>: ODBC isolation set to: Read Committed
> I. 04/13 20:46:15. <Main>: Connected
> E. 04/13 20:46:15. <Main>: Error: [-10002] ODBC: [Sybase][ODBC
> Driver][Adaptive Server Anywhere]Column 'last_upload_time' not found (ODBC
> State = 42S22, Native error code = -143)
> E. 04/13 20:46:15. <Main>: Error: The MobiLink system table 'ml_user' is
> missing column 'last_upload_time'
> I. 04/13 20:46:15. <Main>: Disconnected
> I. 04/13 20:46:15. <Main>: MobiLink server finished
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> "Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
> escribió en el mensaje news:425c01dd$1@foru
ms-2-dub...
a[color=darkred]
> http://www.ianywhere.com/developer/product_manuals
news:425bff8c@forums
-2-dub...[color=darkred]
> server
> 'last_upload_time'
How[color=darkred]
??.[color=darkred]
< Spam_bad_rdomarat@ia
nywhere.com>[color=darkred]
no[color=darkred]
> dbdsn
Can[color=darkred]
el[color=darkred]
>
>


David Fishburn

2005-04-13, 8:24 pm

"CC" <softQUITAESTO@gic.es> wrote in news:425d6afd@forums
-2-dub of
sybase.public.sqlanywhere.mobilink:

C> I´ve both ASA 8 and ASA 9 installed in my computer.
C>
C> Today i´ve reinstalled SQL Anywhere 9. All now is version 9. It seems
C> that work, but when i try to start the Mobilink syncronization server
C> (pag. 18) with:
C> dbmlsrv9 -c "dsn=test_consol" -o mlserver.mls -v+ -dl -za -zu+
C>
C> , it gives me this error:
C>
C>
C> E. 04/13 20:46:15. <Main>: Error: [-10002] ODBC: [Sybase][ODBC
C> Driver][Adaptive Server Anywhere]Column 'last_upload_time' not found
C> (ODBC State = 42S22, Native error code = -143)
C> E. 04/13 20:46:15. <Main>: Error: The MobiLink system table 'ml_user'
C> is missing column 'last_upload_time'
C> I. 04/13 20:46:15. <Main>: Disconnected
C> I. 04/13 20:46:15. <Main>: MobiLink server finished

It looks like the database was dbinited using version 8 software.
Can you dberase and dbinit the database over again using 9.x software
and try your test again.

Make sure the absolute path pointing to the database via the DSN points
to the new database and that *no* other ASA engines are running (just to
make sure).

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

CC

2005-04-14, 7:24 am

YESSSS !!!!. It was the PATH string. Many many thanks. I can continue with
the tutorial. Ufffff !!!.


Only two questions:

1) If i have an ASA 8 db, can i convert it into ASA 9 ???. How i must do
that ???.

2) I´m testing Mobilink for syncronitzacion, but maybe i´m wrong and this
not is the best way.


I´ll try to explain (excuse my very bad english) my customer situation, so
if you can suggest or counsel me, i would be very thankful.

My customer has more or less 10 portatil pc working with a software that
works with a database over a local area network, so changes made by one
portatil has to be visible at the others.

They are salesman, and want to take his portatil pc, and go to purchaser
house, and want to continue working with the software.


When they come back to enterprise, they want to syncronize information.

Wich will be the best way to achieve this ???.

I´ve thinked with two databases: one in the server, and one for each
portatil.
Portatil PC will have two DSN, and when they start software, first question
will be: How do you want to work: unplugged or connected to network.

With this way : When i will syncronize ??. Maybe one option that user has to
click ??. If user don´t have to do nothing, better.


Another way will be that Portatil PC work allways with local database, and
if there is conection to central database, then syncronizes those two db.
With this way sincronization will work every minute.


As you can see, i´ve not bright ideas. Any suggestion will be welcome. Many
many thanks for your help.

Greetings from Spain:

Natalia












"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
escribió en el mensaje news:425d6d33@forums
-1-dub...
> This means that the underlying database that you are using is still a v8
> database. When you initialized your database in this tutorial by
executing
> "dbinit consol.db", what version of dbinit were you using? It should be
the
> first line that dbinit outputs to the console.
>
> [90][d:\temp]dbinit consol.db
> Adaptive Server Anywhere Initialization Utility Version 9.0.2.3110
> Creating system tables
> Collation sequence: 1252LATIN1
> Creating system views
> Setting permissions on system tables and views
> Setting option values
> Initializing UltraLite deployment option
> Database "consol.db" created successfully
>
> I suspect that you have ASA v8 in your PATH first, and you are
initializing
> a v8 database, not a v9 database.
>
> --
> 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
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> "CC" <softQUITAESTO@gic.es> wrote in message news:425d6afd@forums
-2-dub...
that[color=darkred]
(ODBC[color=darkred]

> Inc.
> Solutions,
> example,
CA[color=darkred]
> is
invoked[color=darkre
d]
> prepared
closed[color=darkred
]
> 30
> concurrently:
database[color=darkr
ed]
(ODBC[color=darkred]

using[color=darkred]

> a
tables[color=darkred
]
MobiLink[color=darkr
ed]
> news:425bff8c@forums
-2-dub...
tutorial:[color=dark
red]
consolidated[color=d
arkred]
> How
> ??.
> < Spam_bad_rdomarat@ia
nywhere.com>
> no
> Can
it.[color=darkred]
Anywhere[color=darkr
ed]
> el
>
>


Reg Domaratzki \(iAnywhere Solutions\)

2005-04-14, 9:24 am

1) A version 8 database can be upgraded to version 9 using the dbupgrad
utility. To get all of the benefits of version 9 however, you should unload
and reload the v8 database into a new database. The simplest way to do this
is (note that I'm being explicit with the path to dbunload and am using the
v9 dbunload) :

c:\asa90\win32\dbunl
oad.exe -c "dbf=c:\v8.db;uid=dba;pwd=sql" -an c:\v9.db

2) I would have your application always connect to the local database (what
you are calling the portatil database), and include a "Synch" button in the
application that will synchronize all changes made to their database with
the server database, and will also get all changes made by other users at
the same time. The application will always work on the local copy and synch
changes when needed.

--
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
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"CC" <softQUITAESTO@gic.es> wrote in message news:425e4f27@forums
-1-dub...
> YESSSS !!!!. It was the PATH string. Many many thanks. I can continue with
> the tutorial. Ufffff !!!.
>
>
> Only two questions:
>
> 1) If i have an ASA 8 db, can i convert it into ASA 9 ???. How i must do
> that ???.
>
> 2) I´m testing Mobilink for syncronitzacion, but maybe i´m wrong and this
> not is the best way.
>
>
> I´ll try to explain (excuse my very bad english) my customer situation, so
> if you can suggest or counsel me, i would be very thankful.
>
> My customer has more or less 10 portatil pc working with a software that
> works with a database over a local area network, so changes made by one
> portatil has to be visible at the others.
>
> They are salesman, and want to take his portatil pc, and go to purchaser
> house, and want to continue working with the software.
>
>
> When they come back to enterprise, they want to syncronize information.
>
> Wich will be the best way to achieve this ???.
>
> I´ve thinked with two databases: one in the server, and one for each
> portatil.
> Portatil PC will have two DSN, and when they start software, first
question
> will be: How do you want to work: unplugged or connected to network.
>
> With this way : When i will syncronize ??. Maybe one option that user has
to
> click ??. If user don´t have to do nothing, better.
>
>
> Another way will be that Portatil PC work allways with local database, and
> if there is conection to central database, then syncronizes those two db.
> With this way sincronization will work every minute.
>
>
> As you can see, i´ve not bright ideas. Any suggestion will be welcome.
Many
> many thanks for your help.
>
> Greetings from Spain:
>
> Natalia
>
>
>
>
>
>
>
>
>
>
>
>
> "Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
> escribió en el mensaje news:425d6d33@forums
-1-dub...
> executing
> the
> initializing
> http://www.ianywhere.com/developer/product_manuals
news:425d6afd@forums
-2-dub...[color=darkred]
> that
> (ODBC
is[color=darkred]
exists.[color=darkred]
9.0.2.2451[color=darkred]
Solutions,[color=dar
kred]
reserved.[color=darkred]
secret[color=darkred
]
set[color=darkred]
Dublin,[color=darkre
d]
> CA
server[color=darkred
]
> invoked
first[color=darkred]

> closed
60[color=darkred]
deadlock:[color=dark
red]
bytes[color=darkred]

automatically[color=
darkred]
> database
> (ODBC
is[color=darkred]
< Spam_bad_rdomarat@ia
nywhere.com>[color=darkred]
> using
> tables
> MobiLink
machine?[color=darkred]
> tutorial:
> consolidated
[Sybase][ODBC[color=
darkred]
tables.[color=darkred]
problem[color=darkre
d]
and[color=darkred]
the[color=darkred]
needed.[color=darkred]
http://www.ianywhere.com/developer[color=darkred]
http://downloads.sybase.com/swx/sdmain.stm[color=darkred]
> it.
> Anywhere
encuentra[color=dark
red]
>
>


Greg Fenton

2005-04-14, 9:24 am

Reg Domaratzki (iAnywhere Solutions) wrote:
>
> c:\asa90\win32\dbunl
oad.exe -c "dbf=c:\v8.db;uid=dba;pwd=sql" -an c:\v9.db
>

You can also use the ASA 8 and ASA 9 environment variables:

" %ASANY9%\win32\dbunl
oad.exe" -c ...

We use environment vars in the scripts that our team writes so that we
avoid hard-coded paths. I can install ASA into c:\apps\asa9, whereas
someone else might choose the default location (note the double quotes
around paths to handle spaces in directory names).

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/
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com