How to interface with Spiceworks Database

Download and install sqllite odbc driver

Download location 
http://www.ch-werner.de/sqliteodbc

Then install

Create ODBC Connection to Spiceworks

Open Control Panel, Administrative Tools, Data Sources (ODBC)

Under System DSN tab click Add. 
Datasource Name: spiceworks 
Database name: \\yourservername\Spiceworks\db\spiceworks_prod.db 
Lock Timeout: 100000 
No boxes checked

In C# create a datagridview. On load have this executed

string strDSNConnection = "DSN=spiceworks";

            DataTable dtIdea = new DataTable();

            using (OdbcConnection oConn = new OdbcConnection(strDSNConnection))

            {

                OdbcCommand ocmd = new OdbcCommand("Select * FROM tickets ORDER BY Id DESC");

                ocmd.Connection = oConn;

                OdbcDataAdapter oda = new OdbcDataAdapter(ocmd);

                oda.Fill(dtIdea);

                SpiceWorksDatagrid.DataSource = dtIdea;

Needs some cleanup – references items by ID but it’s doable.