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

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

Deploying VB.Net application with Access DB on intranet

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us