943,693 Members | Top Members by Rank

Software Development > VB.NET > Database Connectivity
Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 459
  • VB.NET RSS
Permalink
Jun 2nd, 2009
0

Database Connectivity

Expand Post »
Hi friends,
Can u tell how can i connect to ms access table from a remote pc within LAN. I want to make a small programme for database manipulation on LAN. Whose database will be stored on a single pc and another can access that data from remote pc within LAN. Please help.
Similar Threads
Reputation Points: 10
Solved Threads: 1
Junior Poster in Training
pardeep3dec is offline Offline
87 posts
since Jul 2008
Permalink
Jun 2nd, 2009
0

Re: Database Connectivity

You can go to this link for more reference.

http://www.connectionstrings.com/
http://www.daniweb.com/forums/thread272.html

In a nut shell you need this

Dim cn As OleDbConnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=Path to your database;")

path to your database could be the computer that has the share database. be sure to give the correct rights to the database probably read and write. and of course make sure all users in the local network has access to the folder which the DataBase is.

Hope that helps regards.
Reputation Points: 56
Solved Threads: 56
Posting Pro in Training
jbisono is offline Offline
432 posts
since May 2009
Permalink
Jul 1st, 2009
0

Re: Database Connectivity

Dim cn As OleDbConnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=use ip address its better;")
Reputation Points: 10
Solved Threads: 1
Newbie Poster
eloelo22 is offline Offline
6 posts
since Jul 2009
Permalink
Jul 1st, 2009
0

Re: Database Connectivity

or why dont you try to establish a data source use the data option in the toolbox when you connect the connection string will be available simply copy it
Reputation Points: 10
Solved Threads: 1
Newbie Poster
eloelo22 is offline Offline
6 posts
since Jul 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: updating database record using forms
Next Thread in VB.NET Forum Timeline: how to get the HTML source code of the page embeded with AJAX





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC