How to access the database over the network

lamasat lamasat

I have a c # application installed on your computer first, and the database on the second computer, how can access to the database >>> note ...that the type of database is Access
database

3 Replies

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

Biswa Pujarini Mohapatra12y ago
Provider is basically the oledb reference for access DB and datasource means the path/location of your database.

in your case you have to store your db in a shared location and give that folder necessary permission

hope it helps
lamasat lamasat12y ago
Excuse me please clarify this conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= C:\Documents and Settings\username\" + @"My Documents\AccessFile.mdb";

Biswa Pujarini Mohapatra12y ago

you can access the database from any server. if you know the database name, username and pasword.

public void ConnectToAccess() {     System.Data.OleDb.OleDbConnection conn = new          System.Data.OleDb.OleDbConnection();     // TODO: Modify the connection string and include any     // additional required properties for your database.     conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +         @"Data source= C:\Documents and Settings\username\" +         @"My Documents\AccessFile.mdb";     try     {         conn.Open();         // Insert code to process data.     }         catch (Exception ex)     {         MessageBox.Show("Failed to connect to data source");     }     finally     {         conn.Close();     } }