Visualstudio2019 UWP C# Microsoft.Data.Sqlite (Error code Sqlite 14 on open) RRS feed

  • Question

  • Error SQLITE 14
    connection contains only "BBMP.db" and not the address-of

    Working version uses({SqlitePCL.sqlite3}Server Version"3.26.0")

    Non-Working version uses({SqlitePCL.sqlite3}Server Version"3.28.0")

            protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
                var connectionStringBuilder = new SqliteConnectionStringBuilder { DataSource = "BBMP.db" };

                var connectionString = connectionStringBuilder.ToString();
                var connection = new SqliteConnection(connectionString);

                optionsBuilder.UseSqlite("Data Source=BBMP.db");

                string bbmcCommand = "CREATE TABLE IF NOT EXISTS " +
                        "BBMPCommands(Id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        "CommandId Integer NOT NULL, " +
                        "CommandImage NVARCHAR(50) NOT NULL, " +
                        "CommandName NVARCHAR(50) NOT NULL)";
                SqliteCommand createCmd = new SqliteCommand(bbmpCommand, connection);

    How do I get sqlite 3.26.0 into Non-Working program version?

    Monday, March 16, 2020 5:10 PM

All replies

  • Hi David.Nelson,
    Based on your description, it is mostly related to UWP. So it is recommended to go to Microsoft QA forum and you can get more professional answer.
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, March 17, 2020 6:51 AM