SQL Anywhere Mobile - Mobilink 9.0.2.3044 and SQL Server 2000

Author

Mobilink 9.0.2.3044 and SQL Server 2000

OMTECH

2005-09-29, 1:24 pm

Hello

I have a problem in the synchronization with my palm. I am
using
a palm Zire 31, Sybase 9.0.2.3044. for the Mobilink, the
consolidated base is in SQL 2000 and to connect me with the
mobilink use the ODBC of SQL.

The error that is shown in mobilink is: "Error: [-10002]
ODBC:
[Microsoft][ODBC SQL Server Driver]Restricted dates type
attribute violation (ODBC State = 07006, Native error code =
0,
Column or parameter #4) ", in the script
download_delete_curs
or.
The table that I am synchronizing has 4 fields PK:
codeCompany,
odeOffice, codeCustomer, dateCustomer. The script has select
null, null, null, null.

To what is this error owed?, How can I solve it?

Thank you

Reg Domaratzki \(iAnywhere Solutions\)

2005-09-30, 9:23 am

Can you please post the entire MobiLink output log, when run with the -v+
switch? I had no trouble doing something very similar :

I. 09/30 09:54:30. Adaptive Server Anywhere MobiLink Version 9.0.2.3193
[snip]
I. 09/30 09:54:31. <Main>: ODBC DBMS Name: Microsoft SQL Server
I. 09/30 09:54:31. <Main>: ODBC DBMS Version: 08.00.0760
I. 09/30 09:54:31. <Main>: ODBC DBMS Driver Version: 03.81.9042
I. 09/30 09:54:31. <Main>: ODBC Version supported by the driver: 3.52
[snip]
I. 09/30 09:54:33. <1.5> [rem1]: download_delete_curs
or Admin (open for
read):
SELECT NULL,NULL
I. 09/30 09:54:33. <1.5> [rem1]: Translated SQL:
SELECT NULL,NULL
I. 09/30 09:54:33. <1.5> [rem1]: Truncating table
I. 09/30 09:54:33. <1.5> [rem1]: download_delete_curs
or Admin (close)

If you could also include the schema of the table in question on the
consolidated database, that would also be very useful.

--
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 filter to "Display ALL platforms IN ALL MONTHS"

<OMTECH> wrote in message news:433c241b.2651.1681692777@sybase.com...
>
> Hello
>
> I have a problem in the synchronization with my palm. I am
> using
> a palm Zire 31, Sybase 9.0.2.3044. for the Mobilink, the
> consolidated base is in SQL 2000 and to connect me with the
> mobilink use the ODBC of SQL.
>
> The error that is shown in mobilink is: "Error: [-10002]
> ODBC:
> [Microsoft][ODBC SQL Server Driver]Restricted dates type
> attribute violation (ODBC State = 07006, Native error code =
> 0,
> Column or parameter #4) ", in the script
> download_delete_curs
or.
> The table that I am synchronizing has 4 fields PK:
> codeCompany,
> odeOffice, codeCustomer, dateCustomer. The script has select
> null, null, null, null.
>
> To what is this error owed?, How can I solve it?
>
> Thank you

omtech

2005-10-27, 8:20 am

Hi,

I believe that the problem is because the embedded base
(Sybase
9.0.2.3044) the field is type datetime and in the
consolidated base
(SQL Server 2000) the same field is datetime with size 8.

To solve this, in my script download_delete_curs
or I made
the
following thing: SELECT null,null,null,
convert(datetime,nul
l) and
this worked me.

Thank you

> Can you please post the entire MobiLink output log, when
> run with the -v+ switch? I had no trouble doing something
> very similar :
>
>
> I. 09/30 09:54:30. Adaptive Server Anywhere MobiLink
> Version 9.0.2.3193 [snip]
> I. 09/30 09:54:31. <Main>: ODBC DBMS Name: Microsoft SQL
> Server I. 09/30 09:54:31. <Main>: ODBC DBMS Version:
> 08.00.0760 I. 09/30 09:54:31. <Main>: ODBC DBMS Driver
> Version: 03.81.9042 I. 09/30 09:54:31. <Main>: ODBC
> Version supported by the driver: 3.52 [snip]
> I. 09/30 09:54:33. <1.5> [rem1]: download_delete_curs
or
> Admin (open for read):
> SELECT NULL,NULL
> I. 09/30 09:54:33. <1.5> [rem1]: Translated SQL:
> SELECT NULL,NULL
> I. 09/30 09:54:33. <1.5> [rem1]: Truncating table
> I. 09/30 09:54:33. <1.5> [rem1]: download_delete_curs
or
> Admin (close)
>
>
> If you could also include the schema of the table in
> question on the consolidated database, that would also be
> very useful.
>
> --
> 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 filter to "Display ALL platforms IN ALL MONTHS"
>
>
> <OMTECH> wrote in message
> news:433c241b.2651.1681692777@sybase.com... >
>
>

Sponsored Links