|
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-
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) |
|
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. |
|
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). 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!! 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:
Sorry, but I don't have more clues available - it's a MS SQL related matter IMHO.
(08 Nov '11, 16:55)
Volker Barth
|
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?
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?