C#

private Boolean Connect_to_SQl()
{

    String Constring = @"user id=sa;password=oops;Server=96.444.444.233;Database=oDirectv3"; //This is a Fake IP

    SqlConnection con = new SqlConnection(Constring);

    Boolean Status = false;

    try
    {
        con.Open();

        if (con != null)
        {
            Status = true;
        }
        else
        {
            Status = false;
        }
    }
    catch (SqlException ex)
    {
        MessageBox.Show(ex.Message);
    }
    finally
    {

    }
    return Status;

}

{System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at RemoteUpdater.Form1.Connect_to_SQl() in C:\Work Development\Remote_Updater\RemoteUpdater\RemoteUpdater\Form1.cs:line 75} 

using System;
using System.Linq;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlServerCe;

namespace ModeDifféré
{
    public partial class Connexion : Form
    {
        public Connexion()
        {
            InitializeComponent();
        }

        private void Connexion_load(object sender, EventArgs e)
        {
            createconnexion();
        }

        private void createconnexion()
        {
            /*string chbd= Environment. + "\\BaseGmaoLocale.sdf";
            //string chcon= "Data source=\'[0]'\ BaseGmaoLocale.sdf;";
            SqlCeConnection sqlceconn= new SqlCeConnection(chcon);
            sqlceconn.Open();*/
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string chcon = null;
            SqlCeCommand command;
            SqlCeDataAdapter adapter = new SqlCeDataAdapter();
            adapter.TableMappings.Add("Table", "Connexion");
            DataSet ds = new DataSet();
            string sql = null;
            string login,MotPass;
            sql = "Select login from Connexion where login=@login and MotPass=@MotPass ";
            string chcc= "BaseGmaoLocale.sdf;";
            SqlCeConnection sqlceconn= new SqlCeConnection(chcc);
            sqlceconn.Open();
            try
            {
                  sqlceconn.Open();
                command = new SqlCeCommand(sql, sqlceconn);
                adapter.SelectCommand = command;
                adapter.Fill(ds, "SQL Temp Table");
                adapter.Dispose();
                command.Dispose();
                sqlceconn.Close();

                MessageBox.Show("Number of row(s) - " + ds.Tables[0].Rows.Count);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Can not open connection ! ");
            }
            if (ds.Tables[0].Rows.Count != 0)
            {
                MessageBox.Show("Authentification réussie");
                MenuP m = new MenuP();
                m.Show();
            }
            else
            {
                MessageBox.Show("Login ou mot de passe incorrect veuillez réessayer");
            }
        }
    }
}

Warning	1	The variable 'chcon' is assigned but its value is never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs	
Warning	2	The variable 'login' is declared but never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs	
Warning	3	The variable 'MotPass' is declared but never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs	
Warning	4	The variable 'ex' is declared but never used	C:\Users\Admin\Documents\Visual Studio 2008\Projects\GMAOMobile\ModeDifféré\Connexion.cs