Connect to a remote database

Question

Hi I have a database on my computer( msde ) . All I want to do is connect to that Db and enter some data from another pc. When I use it on my pc it works but from another pc it fails. They are on the same network and can see each other. The error message is SQL server does not exist or acess is denied This is my code //------------------------------------------------------------ ---------------------------------- try { string connectionString = "Initial Catalog=Northwind;Data Source=blackie;Integrated Security=SSPI;"; SqlConnection myConnection = new SqlConnection(connectionString); myConnection.Open(); if( myConnection.Database.Length > 0 ) { MessageBox.Show( "Db Open" , "Open" ); } } catch( Exception ex ) { MessageBox.Show( "Db Closed" + ex.Message , "Closed" ); } //------------------------------------------------------------ ---------------------------------- Also should I be using a OleDbConnection for this . I am using mix mode for security thanks