Exception when querying gbpvr.db3

[bgowland]

I get the following exception when attempting to query the DB from my plugin.

Code:

DVBTR: System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3_errmsg_stmt_interop' in DLL 'System.Data.SQLite.DLL'

I could understand a DB 'locked' exception or various others but I don't understand this DLL entry point error.

Code as follows...

Code:

SQLiteConnection conn = null;
SQLiteCommand comm = null;
SQLiteDataReader dr  = null;

conn = new SQLiteConnection("data source=" + GBInstallDir + "gbpvr.db3");

comm = new SQLiteCommand("SELECT BDA_RECORDING_SOURCE.board, CAPTURE_SOURCE.name, BDA_RECORDING_SOURCE.capture_source_oid FROM BDA_RECORDING_SOURCE INNER JOIN CAPTURE_SOURCE ON BDA_RECORDING_SOURCE.capture_source_oid = CAPTURE_SOURCE.oid", conn);

comm.CommandType = System.Data.CommandType.Text;
comm.Connection.Open();
dr = comm.ExecuteReader();

To be honest, I'm not sure where I got that SQL query from as it was a couple of months ago when I did it. I think it was probably a VS DataSet wizard generation. It looks OK to me as far as I can tell.

I don't understand the 'entry point' thing. Any ideas? Google isn't helping.

[EDIT] The exception occurs at the comm.ExecuteReader() point.

Cheers,
Brian

[sub]

Sorry, I'm not really sure. Its not something I've come across.

I dont use the SQLite classes directly. I use the generic data access classes and it seems to work fine so you might want to try that.

[bgowland]

I dont use the SQLite classes directly. I use the generic data access classes and it seems to work fine so you might want to try that.

Thanks - I'll try the generic stuff to see if it makes a difference but I think it's due to me doing this from within a plugin.

I just tried the same code in my command-line exe and it worked without a hiccup. Problem is - I want the exe to be just a drone, i.e., the plugin should work out an available tuner and tell the exe to use it.

LOL - nothing's ever easy. Good job I've got a sense of humour.

Cheers,
Brian

[Ommina]

Entry Point Not Found -- something is trying to call a function in the DLL and not finding it.

Sooo, I'd check to ensure that the version of the SQLite DLL and the SQLite data providers are playing well.

I'm using the SQLite provider and the SQLite DLL sub includes with the gbpvr install, I'll see if I can come up with some version numbers.

[JavaWiz]

Make sure you reference the System.Data.SQLite.dll in the gbpvr directory. It should display as version 1.0.30.1 in the properties.

The order I use is something like this:

Code:

private SQLiteDataReader mSqlDataReader = null;
private SQLiteConnection mSqlConn = null;

public SQLiteDataReader OpenSqlReader(string sqlStatement, string dbLocation)
{
    mSqlConn = new SQLiteConnection("Data Source=" + dbLocation + ";Version=3;New=True;Compress=True;");
    mSqlConn.Open();
    
    SQLiteCommand cmd = new SQLiteCommand(sqlStatement, mSqlConn);
    mSqlDataReader = cmd.ExecuteReader();
    return mSqlDataReader
}


public void CloseSqlReader()
{
    if (mSqlDataReader != null)
    {
        mSqlDataReader.Close();
        mSqlDataReader.Dispose();
    }
    if (mSqlConn != null)
    {
        mSqlConn.Close();
        mSqlConn.Dispose();
    }
    mSqlDataReader = null;
    mSqlConn = null;
}


public void someMethod()
{
    string sql = "SELECT * FROM Movies WHERE title LIKE '@@%'";
    SQLiteDataReader dr = OpenSqlReader(sql, MovieWizDbLoc);
    if (dr.HasRows)
        while (dr.Read())
        {
            MovieEntry me = loadMovieInfoRowFromDB(dr);
            list.Add(me);
        }
    CloseSqlReader();
}

basically, someMethod drives the code to :

1) Open the reader with specific sql and dbName
2) Process the result set
3) Close the SQLite connection and clean up the objects

I've left the try catch blocks out for clarity

[bgowland]

Make sure you reference the System.Data.SQLite.dll in the gbpvr directory. It should display as version 1.0.30.1 in the properties.

Thanks - that was it. My code was fine, just the version of the SQLite ADO.NET provider.

I had v1.0.42.0 installed on my machine and was using that in project references. I've reverted back to an older version - it's actually 1.0.31.0 as SourceForge doesn't have an archive of 1.0.30.1. It works from the plugin now.

Cheers,
Brian