To manipulate the Media Portal SQLite3 databases via JDBC, you can use the JDBC driver from: http://www.ch-werner.de/javasqlite/
Following the instructions worked for me. For a general DB GUI client, I use DBVisualizer (http://www.minq.se/products/dbvis/), although any Java based client will probably work. This setup allows me to browse and manipulate the MP databases much more efficiently than with "SQLite Database Browser.exe", which is included in the MP "/docs" directory.
This is important to me because recent MP builds seem to have problems dealing with my TVGuide info and setting up my external channel mappings. Being able to access and manipulate the data directly is a big time saver.
Ideally, I wanted to access the SQLite databases via ODBC so that I could manipulate data with MS Access. However, I couldn't quite get that to work. I did notice a previous post though were someone got ODBC to work with MS Excel, so perhaps I'm just missing something simple. (Previous post using SQLite ODBC with Excel: http://nolanparty.com/mediaportal.sourceforge.net/phpBB2/viewtopic.php?t=9163)
Following the instructions worked for me. For a general DB GUI client, I use DBVisualizer (http://www.minq.se/products/dbvis/), although any Java based client will probably work. This setup allows me to browse and manipulate the MP databases much more efficiently than with "SQLite Database Browser.exe", which is included in the MP "/docs" directory.
This is important to me because recent MP builds seem to have problems dealing with my TVGuide info and setting up my external channel mappings. Being able to access and manipulate the data directly is a big time saver.
Ideally, I wanted to access the SQLite databases via ODBC so that I could manipulate data with MS Access. However, I couldn't quite get that to work. I did notice a previous post though were someone got ODBC to work with MS Excel, so perhaps I'm just missing something simple. (Previous post using SQLite ODBC with Excel: http://nolanparty.com/mediaportal.sourceforge.net/phpBB2/viewtopic.php?t=9163)