The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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)

asked 05 Nov '11, 08:49

Kavita%20Nemad's gravatar image

Kavita Nemad
36337
accept rate: 0%

edited 05 Nov '11, 18:58

Volker%20Barth's gravatar image

Volker Barth
30.9k309457667

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?

(05 Nov '11, 09:06) Derli Marcochi
Replies hidden

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?

(05 Nov '11, 09:15) Kavita Nemad

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.

permanent link

answered 05 Nov '11, 10:48

Derli%20Marcochi's gravatar image

Derli Marcochi
1.6k323877
accept rate: 33%

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).

permanent link

answered 05 Nov '11, 18:52

Volker%20Barth's gravatar image

Volker Barth
30.9k309457667
accept rate: 33%

edited 05 Nov '11, 18:57

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)

(07 Nov '11, 07:48) Kavita Nemad
Replies hidden

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.

(07 Nov '11, 08:29) Volker Barth
1

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.

(08 Nov '11, 23:57) Kavita Nemad

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!!

permanent link

answered 08 Nov '11, 15:43

Derli%20Marcochi's gravatar image

Derli Marcochi
1.6k323877
accept rate: 33%

1

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.

(08 Nov '11, 16:55) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×295
×145
×125
×28

question asked: 05 Nov '11, 08:49

question was seen: 2,573 times

last updated: 09 Nov '11, 02:44