Database Connectivity

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Jul 2008
Posts: 54
Reputation: pardeep3dec is an unknown quantity at this point 
Solved Threads: 1
pardeep3dec pardeep3dec is offline Offline
Junior Poster in Training

Database Connectivity

 
0
  #1
Jun 2nd, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: May 2009
Posts: 186
Reputation: jbisono is an unknown quantity at this point 
Solved Threads: 24
jbisono's Avatar
jbisono jbisono is online now Online
Junior Poster

Re: Database Connectivity

 
0
  #2
Jun 2nd, 2009
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.
If your already resolved your issue, flag it as solved.
José Bisonó
Reply With Quote Quick reply to this message  
Join Date: Jul 2009
Posts: 6
Reputation: eloelo22 is an unknown quantity at this point 
Solved Threads: 1
eloelo22 eloelo22 is offline Offline
Newbie Poster

Re: Database Connectivity

 
0
  #3
Jul 1st, 2009
Dim cn As OleDbConnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=use ip address its better;")
Reply With Quote Quick reply to this message  
Join Date: Jul 2009
Posts: 6
Reputation: eloelo22 is an unknown quantity at this point 
Solved Threads: 1
eloelo22 eloelo22 is offline Offline
Newbie Poster

Re: Database Connectivity

 
0
  #4
Jul 1st, 2009
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
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC