Cannot add sqlite db file to Word adding deployment

Question

I developed C# Word add-in which populates some data from database file. It is working fine while I am running through Visual studio running. But if I publish it cannot connect to database.

Here is how I get data from database:

SQLiteConnection con = new SQLiteConnection(ThisAddIn.connectionString);
            con.Open();

            var command = con.CreateCommand();
            command.CommandText =
            @"
                SELECT *
                FROM JK
                WHERE article_number = $article_number
            ";
            command.Parameters.AddWithValue("$article_number", textFromDoc);

            using (var reader = command.ExecuteReader())
            {
                while (reader.Read())
                {
                    var title = reader.GetString(2);
                    var article = reader.GetString(3);

                    ResultForm resultForm = new ResultForm();
                    resultForm.setArticle(title, article);
                    resultForm.ShowDialog();
                }
            }

public static string connectionString = @"Data Source=E:\projects\c#\TBPWordAddin\WordAddIn1\codexes.db";

Am I doing something wrong or do I need to include file in another way? Any help will be appreciated.

Also I tried publishing using Visual studio installer and it connected to database but the add in didnot lounched on other computers.

As it cannot connect to the DB, then I would guess it is an issue with the connection string. So you should post that in the question. — jason.kaisersmith
– jason.kaisersmith, Commented Jan 17, 2022 at 11:36

Eugene Astafiev · Accepted Answer · 2022-01-18 21:59:12Z

1

The connection string contains an absolute path which can be changed after publishing an application. I'd suggest using a relative path instead - in that case you will be able to find the Db easily. You may check out the following threads for more information on such kind of issues:

But if I publish it cannot connect to database.

Make sure the Db path (see the connection string) corresponds to the hardcoded value in the application used.

edited Jan 18, 2022 at 21:59

answered Jan 17, 2022 at 13:07

Eugene Astafiev

49.8k3 gold badges28 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Tekemuradov Over a year ago

I have tried using relative path but no success. Also I pasted db file in My documents folder so I could easily access it. In the debug mode it works but when I publish it it falls

Eugene Astafiev Over a year ago

How do you publish the add-in? Do you use a ClickOnce installer? Where do you install the add-in?

Tekemuradov Over a year ago

Yes by using ClickOnce installer. I have installed on C disk program files folder. But I also used Visual Studio Installer. But on other computers it did not run on others

Eugene Astafiev Over a year ago

It seems you have mixed the installation. You need to use a single installer - ClickOnce or MSI (not two together).

Collectives™ on Stack Overflow

Cannot add sqlite db file to Word adding deployment

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related