Knowledgebase
How to use Open Office Database in Cellica Database?
Posted by Cellica Support Team on 01 May 2013 01:05 PM
You can use Cellica Database for Open Office.

You need to use SQLite Database for connection with Open Office.

Please follow the following steps for to use Open Office Database in Cellica Database.


1.    Download and Install SQLite ODBC Driver from following path,
      http://ch-werner.de/sqliteodbc/sqliteodbc.exe

2.    Download and put “SQLiteDB.sqlite” at your appropriate path.
      http://www.cellica.com/download/SQLiteDB.sqlite

3.    Create ODBC DSN for “SQLiteDB.sqlite” database using SQLite3 ODBC Driver.

4.    Connect OpenOffice to a SQLite Database using ODBC DSN created in Step 3.
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org#Connecting_OpenOffice_to_a_SQLite_database


5.    Create Tables in newly Created OpenOffice Database.

6.    Now use ODBC DSN created in Step 3 in CellicaDatabase application for Profile creation.

You can use following link for more information about Open Office and SQLite DB.
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org
(4 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