Ultralite Scyncronization failed in sybase 12

[Former Member]

Hi all,

We are using ultralite as a remote database (version 11.0.1.2376) and Sql Server 2008 as consolidated database . Our mobilink server version is 12.0.1.3484. We are running mobilink server on Windows server 2008 R2 enterprise (64 bit).

We have got following error during synchronization-

I. 2011-11-05 23:17:23. SQL Anywhere MobiLink Server Version 12.0.1.3484
I. 2011-11-05 23:17:23.
I. 2011-11-05 23:17:23. Copyright © 2001-2011, iAnywhere Solutions, Inc.
I. 2011-11-05 23:17:23. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved.
I. 2011-11-05 23:17:23. Use of this software is governed by the Sybase License Agreement.
I. 2011-11-05 23:17:23. Refer to http://www.sybase.com/softwarelicenses.
I. 2011-11-05 23:17:23.
I. 2011-11-05 23:17:23. This server is licensed to: I. 2011-11-05 23:17:23. Test
I. 2011-11-05 23:17:23. Test
I. 2011-11-05 23:17:23. Running Windows 2008R2 Build 7601 Service Pack 1 on X86_64
I. 2011-11-05 23:17:23. Server built for X86_64 processor architecture
I. 2011-11-05 23:17:23. <main> Local file for remote synchronization logs: 'mlsrv.mle'
W. 2011-11-05 23:17:23. <main> [10064] Unknown users will be added automatically (when there is no authenticate_user script)
W. 2011-11-05 23:17:23. <main> [10051] Unrecognized ODBC driver 'SQLSRV32.DLL'. The functionality and quality of ODBC drivers varies greatly. This driver may lack functionality required for successful synchronizations. Use at your own risk
I. 2011-11-05 23:17:23. <main> This software is using security technology from Certicom Corp.
I. 2011-11-05 23:17:23. <main> MobiLink server started
I. 2011-11-05 23:17:23. <main> Started RTNotifier 'RTNotifier1'
E. 2011-11-05 23:18:31. <1> [-10344] The remote database identified by remote ID '991716ee-6212-4f96-a8ee-f241040407e2' is already synchronizing: orphaned UltraLite synchronization detected
E. 2011-11-05 23:18:36. <2> [-10002] Consolidated database server or ODBC error: ODBC: [Microsoft][ODBC SQL Server Driver]Invalid precision value (ODBC State = HY104, Native error code = 0, Column or parameter #1)

Where as Sqlanywhere database synchronization works fine with this mobilink server. The problem is with Ultralite version 12.0.1 only

Please help us.

Thanks in advance. Kavita Nemad Palewar Techno Solutions Nagpur (www.palewar.com)

[former_SQLA_member1694870]

I have a question for you related to the 3484 build you described. We are discussing in another entry about the "Check for updates" option that does not complete successfully. Do you know when the 3484 build became available for download for Ultralite?

[Former Member]

Hi Derli,

It is available on 31 Oct 2011.

Product Name: SQL Anywhere Platform: Windows x86/Windows x64 Release Version: 12.0.1 Release Description: Express Bug Fix, Update of 12.0.1 to build 3484 Release Date: 31 Oct 2011

Do you have any idea about the above issue?

[former_SQLA_member1694870 · Accepted solution]

Not that will necessarily help but the 10051 message is the issue I would concentrate first. Did you recall seeing this message before updating to 3484?

[10051] Unrecognized ODBC driver 'SQLSRV32.DLL'. The functionality and quality of ODBC drivers varies greatly. This driver may lack functionality required for successful synchronizations. Use at your own risk.

[former_SQLA_member1694870]

I can't say for sure since we don't have the same environment you have for testing but I am still not sure about the DLL file name SQLSRV32.DLL. Are you running as a 32-bit application? If you are running a 64-bit app in a 64-bit box I would expect a xxx64.dll ? Maybe Volker has additional clues to offer!!

[VolkerBarth]

No, the naming issue isn't a clue: Like several other system DLLs, the 64-bit and the 32-bit SQL Server driver are both named SVRSRV32.DLL - just as the ODBC Administrator is called ODBCAD32.EXE in both bitness variants. So they can be distinguished by their location:

• 64-bit on 64-bit Windows: C:\\programs\\System32
• 32-bit on 64-bit Windows: C:\\programs\\SysWow64

Sorry, but I don't have more clues available - it's a MS SQL related matter IMHO.

[VolkerBarth]

Make sure you are using a supported ODBC driver for MS SQL Server - cf. this list for consolidated databases with MobiLink 12.0.1.

AFAIK, they demand the "SQL Server Native Client" driver (sqlncli.dll or sqlncli10.dll) whereas you still seem to use the older "SQL Server" driver (sqlsrv32.dll).

[Former Member]

Hi Volker Barth,

Thanks for your prompt response. We have two virtual machines on a server. We have Sql server installed on one vm and on another vm sybase is installed. We cann't find "SQL Server 2008 Navtie Client" driver on the machine where we have intalled sybase. We have tried to install it using "sqlncli.msi" but could not install it. We have got the following error during installation.

"An error occured during the installtion of assembly 'Microsoft.VC80.CRT,version="8.0.50727.1833",type="win32",publikeyToken="1fc8b3b9a18e3b",processorArchitectre="x86". Please rfer to help Help and Support for more infoemation.HRESULT: 0x8007054F."

Can you please help us to sort it out. Thanks in advance.

Kavita Nemad Palewar Techno Solutions (www.palewar.com)

[VolkerBarth]

Sorry, I can't tell you how to install that driver. However, I would think it's part of the SQL Server 2008 client tools or ODBC/OLE DB installation.

[Former Member]

Hi Volker and Derli,

Many thanks for your help. We have fixed this issue. We have installed the Sql server 2008 express edition on the vritual machine where sybase is installed and now we have got the driver "SQL Server 2008 Native Client" and ultralite syncronization is working fine.