ODBC connectivity in C#

Hi,

    I assume that you have already installed MySQL/ORACLE and their respective ODBC driver . Along with this basic knowledge of SQL queries.

Now, lets get started with C# ODBC connectivity.

1. Before writing any code , you need to include correct namespace.  

      using System.Data.Odbc;

2. For creating connection we will be using OdbcConnection class.

What is LDAP, AD, ADAM ?

Well,

Before getting started with an explanation  i would like if you go through following links to get basics of LDAP, AD, ADAM.

Here are the links :

  LDAP : 

     en.wikipedia.org/wiki/Lightweight_Directory_Access_Protocol

or refer RFC 4511

     ietf.org/rfc/rfc4511.txt

Deploying ASP.NET MVC application on windows 7 IIS web server

Configuring IIS on Windows 7 :

1. Go to Control Panel -> Programs -> Turn Windows Features on or off .
   
   1.1 Internet Information Services (IIS) is checked, even explore the depth of this root     folder and check almost all checkboxes .
   1.2 Windows Process Activation Service and explore depth of this folder.
   
2. Go to Control Panel -> Administrative Tools -> services-> IIS related services.
   
3. Now you can open IIS manager, steps are:
   3.1 open run window and then enter “inetmgr” .
   

Publishing web application through Visual studio 2012 express :

1. Right click on projectName in solution explorer and click publish.
   
2. Now, give profile name :XXXX
   
3. serviceURL : If publishing from localhost then “localhost”.
   
4. Site/Application : “Default Web Site/requiredname”
   
5. Destination URL : “http://localhost:80/requiredname”
   
6. click on Validate connetion to see GREEN checked sign.
   

Log4Net in ASP.NET MVC

Confuguring Log4Net in ASP.NET MVC 4 Web Application :

1.  Download Log4Net :

http://logging.apache.org/log4net/download.html 

2. Add reference in ASP.Net MVC 4 application :

Solution Explorer > right click on project-name > add references > browse Log4Net.dll

3. Modify Web.config File :

<configuration>
.
.
.
.