Reply to thread

Message

I misquoted the exception line. If you look in the code, it actually calls the full path to the database file. The problem is very strange. It traces back to the MediaPortal.Database file which is expected since that is where SQLite.NET resides. However, I tried debugging some other peoples code (MyTVseries and MyDVDs) and I get the same exception on their code even though we know that it compiles and runs correctly since their code works.

Can this exception be a problem with debugging with SQLite?

Basically, since I couldn't figure it out, I've turned to using the System.Data.SQLite opensource class located at http://sqlite.phxsoftware.com/. I haven't had any problems with using this code. The only issue is that its harder to use data from a query.

If I can get the built-in SQLite reader working, then great. If not, I'm going to stick with this other method. It follows the standard ADO.NET database access methods, so that is nice.

Jesse

<blockquote data-quote="Hesse" data-source="post: 72960" data-attributes="member: 23814">I misquoted the exception line.&nbsp; If you look in the code, it actually calls the full path to the database file.&nbsp; The problem is very strange.&nbsp; It traces back to the MediaPortal.Database file which is expected since that is where SQLite.NET resides.&nbsp; However, I tried debugging some other peoples code (MyTVseries and MyDVDs) and I get the same exception on their code even though we know that it compiles and runs correctly since their code works. Can this exception be a problem with debugging with SQLite?Basically, since I couldn't figure it out, I've turned to using the System.Data.SQLite opensource class located at <a href="http://sqlite.phxsoftware.com/" target="_blank">http://sqlite.phxsoftware.com/</a>.&nbsp; I haven't had any problems with using this code.&nbsp; The only issue is that its harder to use data from a query.If I can get the built-in SQLite reader working, then great.&nbsp; If not, I'm going to stick with this other method.&nbsp; It follows the standard ADO.NET database access methods, so that is nice.Jesse</blockquote>

[QUOTE="Hesse, post: 72960, member: 23814"] I misquoted the exception line. If you look in the code, it actually calls the full path to the database file. The problem is very strange. It traces back to the MediaPortal.Database file which is expected since that is where SQLite.NET resides. However, I tried debugging some other peoples code (MyTVseries and MyDVDs) and I get the same exception on their code even though we know that it compiles and runs correctly since their code works. Can this exception be a problem with debugging with SQLite? Basically, since I couldn't figure it out, I've turned to using the System.Data.SQLite opensource class located at [URL="http://sqlite.phxsoftware.com/"]http://sqlite.phxsoftware.com/[/URL]. I haven't had any problems with using this code. The only issue is that its harder to use data from a query. If I can get the built-in SQLite reader working, then great. If not, I'm going to stick with this other method. It follows the standard ADO.NET database access methods, so that is nice. Jesse [/QUOTE]