Our system uses MS SQL Server 2005 as consolidated database, ASA10 mobilink server and ultralite db (latest ebf 10.0.1.4239), odbc driver for MS SQL version is 2005.90.3042.00. I've got a problem uploading blobs bigger than ~400kb from mobile device to consolidated database. Smaller sizes make no problem. In the mobilink log I obtain this error messages:
E. 2011-06-21 23:44:30. <2> [-10072] Unable to insert into table 'DocLib' using upload_insert E. 2011-06-21 23:44:30. <2> [-10061] An error occurred while uploading an insert row into table 'DocLib'.
( table DocLib contains one column with blob data )
When I use ASA as consolidated database, there's no problem to upload blobs of any size on the table with the same structure. Any other desktop application using the same odbc as mobilink has no problem to write blobs of any size to this table even on MS SQL database.
Mobilink is started with this command line: mlsrv10 -c "DSN=<database>;UID=<login>;PWD=<pass>" -v+ -o log.mle
This problem occures on Windows 2003 server OS with MSSQL 2005 and on desktop Windows XP with MSSQL 2005 too. Platform for remote database is Windows mobile 6.5
Is there any way to solve this problem on MS SQL Server? Or are there needed some other technical details?
Any help appreciated, thanks in advance
The recommended ODBC driver for this configuration is 2005.90.2047.00, as stated here. We haven't tested with the ODBC driver you are using, and it may not work. Not all ODBC drivers work properly, as we've found time and time again in our testing, so it is important to stick to our recommendations.
answered 06 Jul '11, 09:12
I have tried to upload a 10 MB blob to my MSSQL 2005 with the MobiLink server version 10.0.1.4239 and ODBC driver version 2005.90.1399.00 on Windows XP and it works very well. Could you post the definition of your upload table that contains the ~400KB blob (please modify the table and column names if they mean something that is sensitive). -- Thanks.
answered 07 Jul '11, 10:20