Author Topic: How to to use Open Office Database in Cellica Database?  (Read 9667 times)

CellicaTeam

  • Administrator
  • Hero Member
  • *****
  • Posts: 693
    • View Profile
How to to use Open Office Database in Cellica Database?
« on: August 27, 2012, 12:31:22 AM »
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