Knowledgebase
46Products 8Database 12Forms 2Database Relationships 2General 1 Product Updates 8Installation and upgrade 1Manuals 1Backup and Restore 18Video Tutorials
Knowledgebase:
How to use images stored in database with Cellica Database?
Posted by Cellica Support Team, Last modified by Cellica Support Team on 23 July 2014 11:07 AM

With “Cellica Database” you can transfer images stored in desktop database to device in binary format.  In device side, “Cellica Database” application you can view and modify images received from desktop database. Also you can add new images using device camera or can use existing picture stored in memory on device. This image data sync to desktop database.
 

Following is list of commonly used databases and supported column datatype used for storing image data in desktop database to work with "Cellica Database".

 

Database

Datatype

Minimum ODBC driver version required

MS Access

OLE Object

  

MS SQL Server

image, varbinary(MAX)

"Image" datatype
    -ODBC Driver 11 for SQL Server
    -SQL Server Native Client 10.0
    -SQL Server Native Client 11.0

varbinary(MAX) datatype
    -SQL Native Client  (Will not work if database is on Remote Server)
    -ODBC Driver 11 for SQL Server
    -SQL Server Native Client 10.0
    -SQL Server Native Client 11.0

My SQL

longblob, blob

MySQL ODBC 5.1 Driver or Above

Oracle

BLOB

 
 

 For more information about how to work with images in MS Access check following document,

http://www.cellica.com/KB/Cellica_KB_2013_EE_778.pdf

 

(16 vote(s))
This article was helpful
This article was not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Help Desk Software by Kayako cellica.kayako.com