How to I add sqlite database file when creating .exe file(setup and deployment)

Question

0.00/5 (No votes)

See more:

Okay, the question has been asked multiple times, and I have research and tried several solutions and suggestions from different forums/exchange sites. I'm new to vb.
I'm working on a small project that requires database(sqlite), and I access the db like this:

VB

Dim con As New SQLiteConnection("Data Source=C:\proj1\db1.db")

Every thing works as expected on my system, but when i create .exe file of the project and install the .exe file on other system, it doesnt work since there is no database file. what should I do?

What I have tried:

I have tried this one How do I include my SQLite database in my published vb.net project? - Stack Overflow[^]

Posted 20-Jun-18 13:13pm

Member 12755105

Updated 15-Jul-21 5:19am

Add a Solution

Comments

RedDk 20-Jun-18 20:51pm

Try including the database file. I can read this article and I can see that it's about a deployment. The pseudofact remains though, that I can manage packages through my VS installation and that management typically will install assemblies to the GAC but ... that's probably the reason your package doesn't work. There's no SQLite assembly installed.

How did you reference System.Data.SQLite, if you don't mind me asking?

Member 12755105 20-Jun-18 21:24pm

I feel so stupid, I've resolved the problem by simply putting the .dB file to my main project folder and change the data source string to db1.db. Besides, I have to add the .dB file manually during the setup build to application folder where all the assembly files are inside. Now it works. Thanks anyway

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 15290571 · Answer 1 · 2021-07-15T05:19:00

Solution 1

you can help me I have some problems?

Posted 15-Jul-21 5:19am

Member 15290571

Comments

Richard Deeming 15-Jul-21 11:45am

"Me too" is not a solution to this question.

If you want to post a comment, click the "Have a Question or Comment?" button under the question.

Do not post your comment as a "solution".

How to I add sqlite database file when creating .exe file(setup and deployment)

1 solution

Solution 1

Add your solution here

Preview 0

How to I add sqlite database file when creating .exe file(setup and deployment)

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us