2007-07-19, 06:04 AM
psycik Wrote:Ahh, may have just found it... in your logs you try loading Database factory: System.Data.OleDb.OleDbFactory
It should be
System.Data.SQLite.SQLiteFactory
Hmm, maybe you've set you db to MusicLibrary2.db3, but you config app say MSAccess....
Can you check
I was puzzled about that as well, but I do not know much about these database connectors. In the meantime I had reverted back to ML 5.4 _WITH_ SQLlite. In config.xml I see the following :
Code:
<DatabaseConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Program Files\devnz\gbpvr\musiclibrary2.db3";User Id=admin;Password=</DatabaseConnectionString>
<DatabaseProviderFactory>System.Data.OleDb.OleDbFactory</DatabaseProviderFactory>
Next I install ML2-6.3 as described above. I only choose the default ML2 SQLlite database and leave all other ML2 settings on their defaults:
Code:
<DatabaseConnectionString>Data Source="C:\Program Files\devnz\gbpvr\MusicLibrary2.db3";Version=3;New=True;</DatabaseConnectionString>
<DatabaseProviderFactory>System.Data.SQLite.SQLiteFactory</DatabaseProviderFactory>
Code:
<DatabaseConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Program Files\devnz\gbpvr\MusicLibrary2.db3";User Id=admin;Password=</DatabaseConnectionString>
<DatabaseProviderFactory>System.Data.OleDb.OleDbFactory</DatabaseProviderFactory>
I don't understand how this happens. The stange thing is that ML2-5.4 functions quite well with this DatabaseProviderFactory