using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
using Console = System.Console;
using Microsoft.Data.Odbc;


namespace dbf
{
	public class Form1 : System.Windows.Forms.Form
	{
		private System.ComponentModel.Container components = null;

		public Form1()
		{

			InitializeComponent();
/// ACCESS! /////// :) 
			try
			{
				OleDbConnection cn = new OleDbConnection();
				cn.ConnectionString=  "Provider=Microsoft.Jet.OLEDB.4.0;"+@"Data  Source=E:\Projects\DataBases\stuff.mdb";

				cn.Open();
				cn.Close();
			}
			catch
			{
				MessageBox.Show("error oledb access!");
			}
/////// OLEDB //// :(
			try
			{
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString =  "Provider=Microsoft dBase Driver;Data Source=localhost;Initial Catalog=stuff;";
cn.Open();
cn.Close();
			}
			catch
			{
				MessageBox.Show("error oledb!");
			}
////// ODBC ////// :(

				try
				{ 
					string MyConString = "DRIVER={Microsoft dBase Driver};" + "SERVER=localhost;" +	"DATABASE=stuff;";
					OdbcConnection MyConnection = new OdbcConnection(MyConString);    
					MyConnection.Open();
  					MessageBox.Show("\n !!! success, connected successfully !!!\n");    
					//Display connection information
					MessageBox.Show("\tDriver:" + MyConnection.Driver);
					MessageBox.Show("\tServerVersion:" + MyConnection.ServerVersion);
					MyConnection.Close();
				}
				catch {
				MessageBox.Show("error odbc");
				}

				///
			}
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}
		#region Windows Form Designer generated code
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			this.Size = new System.Drawing.Size(300,300);
			this.Text = "Form1";
		}
		#endregion
		[STAThread]
		static void Main() 
		{
			Application.Run(new Form1());
            	}
	}
}