ODBC Connectivity

 

By default Xinorbis uses an excellent database engine called SQlite to store the Folder History data archive. SQlite is part of the the Xinorbis installer and is included in the ZIP archive, it does not need to be installed separately.

The X.Database tool is available free to all Pro users, and allows direct access to the SQL data contained with the Xinorbis SQL database.

For many users SQlite will be more than adequate, but for power or Enterprise users it probably isn’t going to be powerful enough.

That’s why versions 5.2 and above of Xinorbis come with ODBC connectivity. ODBC allows Xinorbis to talk to a wide range of different databases including Microsoft SQL Server, mySQL and Oracle.

 

How to configure Xinorbis to use ODBC:

 
(1)
Install your database engine of choice and ensure that all of the necessary ODBC plugins for the database are installed too.
 
(2)
Create a database called XINORBIS. (choose something else if you really want to)
 
(3)
Edit the config.ini file that’s located in the root of the Xinorbis install and edit the two ODBC parameters:
 
 

useodbc=1
connectionstring=<enter the connection string here>

 
 

For example, the connection string I use to connect to SQLServer Express 2008 on my development PC is:

 
 

connectionstring=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XINORBIS;Data Source=PAFCOM\SQLEXPRESS

 
 

Please see your database administrator for information on creating the ODBC connection string.

 
(4)
That’s it!
 

The underlying operation will not be affected by using ODBC instead of SQlite, all functions and features will work as normal.

 

The “Backup your Xinorbis database” option is not available when using ODBC.

 
Have a look at the excellent www.connectionstrings.com website for more information on creating connection strings.