Advice - Windows Application Connectionstring Setting WPF

Abhilash J A

9y884

Hello everyone,

I have created 2 .exe wpf windows application. One is for client machine and 2nd oen is Admin machine. And the machines should under common network. Then, I am planing to populate, a ask window for adding client's IP address after installation client .exe on client machine only. Then add their ip to the sqlliteconnectionstring by using SQLiteConnectionStringBuilder class. Is this approach good or bag? Example,

"\\192.168.1.100\Model\test.s3db;"

By using this technique, is this become any problem with respect to the necessary permissions to read/write in order to give access to the other machine and at the same time protect file ?

Please clarify me...

Thanks,

Abhilash.J.A

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
As Sqlite has been made for embedded application not for client/server applications to be used more than a user. It may cause concurrent issues and may lead to corruption of database file.

However, you may use MySql (open source) to work with this type.

Check reference:
http://stackoverflow.com/questions/4906912/how-do-i-give-a-connection-string-to-a-server-on-a-network

Moreover, coming to your question, check below link
http://stackoverflow.com/questions/17303076/sqlite-cannot-open-network-file-programatically-even-though-worked-before

Hope this helps!
Amit Gupta9y ago
You can connect your Sqlite db on a LAN (as stated on earlier post).

MySql is an open source db, hence it is not payable.

Read the article carefully before proceeding.
Abhilash J A9y ago
Hello Amit Sir,

I have already developed WPF windows app with SQLite db. Alternatively if its not possible in Sqlite i could migrate it in MySql. May I need a licence(paid) to distribute MySQL commercially ? I can not use paid one database. Actually, I wanted it to deploy on other machines without having to install mysql individually/saperately on each machine. Please suggest me ways...
Amit Gupta9y ago
There are a lot of ways to install database with your application. Keep in mind that installation is one time work and working with database is in day to day.

Please have a look to the link that I had posted and go for the best.
Abhilash J A9y ago
Hello Amit Sir,

The customer demanding, they don't want addition database deployment instead the want to install .exe file with database also should install at the same time. So I did use SQLite db. in my windows application.