Deploying VB.Net application with Access DB on intranet

Question

0.00/5 (No votes)

See more:

Hi all,

I've developed an application for school on vb.net and ms-access database. I've experienced its deployment on stand alone computer and cheers.. Now i need to deploy it on local intranet of 4-5 PCs. But i don't know how to achieve this. I want my application to access database from a central point and all users uses the same database. I need a help on it. Thanks

Ovais

Posted 3-Nov-13 20:19pm

Ovais Memon

Add a Solution

Comments

walterhevedeich 4-Nov-13 2:28am

1. Put your database on a location that is accessible(through network) by the target PCs.
2. Utilize the connection string property of your application's App.Config. In the connection string, put the IP, user name, password, and other required information. Do not hardcode the connection on your code.

Ovais Memon 4-Nov-13 4:30am

Thanks, let me try and get back to you..

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Bernhard Hiller · Answer 1 · 2013-11-03T20:25:00

Solution 1

The thing to look at is the "connection string" which is normally set in the .exe.config file.
That means: deploy your database somewhere, adjust the connection string in the .exe.config file, and then deploy your application with the modified .exe.config file. The last step (deploy the modified file) could be achieved by a custom action in the msi or by a software distribution system.

Posted 3-Nov-13 20:25pm

Bernhard Hiller

Comments

Ovais Memon 4-Nov-13 2:54am

Bernhard, Kindly see the connection string below.. (In solution).

Bernhard Hiller 4-Nov-13 3:20am

"Data Source=|DataDirectory|\UltraSchoolDB.mdb"
Replace |DataDirectory| with the path to the shared folder, e.g.
"Data Source=\\YourServer\YourShare\UltraSchoolDB.mdb"

Ovais Memon 4-Nov-13 4:30am

Ok, let me try and get back to you.. Thanks

member 8888995 · Answer 2 · 2013-11-03T20:34:00

1.Locate your database file on a server machine.

2.Modify your connection string to access it.
if your using OLEDB driver to connect to access you can use connection string as
Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;

3. Find OLEDB data provider on your machine and modify connection string.

--
Thanks

Ovais Memon · Answer 3 · 2013-11-03T20:53:00

HTML

<connectionstrings>
        <add name="ConnectionString1">
            connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\UltraSchoolDB.mdb;Persist Security Info=True;Jet OLEDB:Database Password=mypassword"
            providerName="System.Data.OleDb" />
    </add></connectionstrings>

Deploying VB.Net application with Access DB on intranet

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0