Knowledgebase
How to use images stored in database with Cellica Database?
Posted 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

 

(15 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