Connect to Mysql from a Windows Application using ODBC

1. Download the mysql connector located here : http://dev.mysql.com/downloads/connector/net/6.0.html 

 2. Add a reference to the mysql.data.dll  (for some reason mysql.data is missing from the .net  reference tab). If that is the case for you downlaod the "Windows Binaries, no installer (ZIP)" version and click on the browse tab and locate the the mysql.data.dll manually.

3. Add the using MySql.Data.MySqlClient to your project.

4.  Create your connection MyConnection.ConnectionString = @"SERVER=" + dbHost.text + ";" + DATABASE=" + Database.text + ";" + "UID=" + dbUsernme.text + ";" + "PASSWORD=" + dbPassword.text + ";";

5. Then Test it.

Forms Authentication and Master Pages

The master page should be automatically removed form authentication what you really need to worry about are the images and the external css that are referenced in the master page. you will need to add the following in your web.config file right before the </configuration>

<location path="images">

<system.web>

<authorization>

<allow users="*"/>

</authorization>

</system.web>

</location>

<location path="css">

<system.web>

<authorization>

<allow users="*"/>

</authorization>

</system.web>

</location>

Read more

IIS 7 on Windows Server 2003

Every time I spend some time away from IIS and related technologies, I always forget that IIS 7.0 cannot be installed on  windows server 2003. However IIS7 is available on vista and windows 2008.
Also the IIS manager 7.0 does not seem to work on windows server 2003.

Create Auto-Reply With Outlook (not Out of Office)

Somebody came into my office one day and ask me this question: How do i create an auto-reply in microsoft outlook. I am like this is easy just go to tools -> out of office. then she said i do not want an out of office but an auto reply.  I want to auto-reply to the customer even if i am in the office.  The rest is GOOGLE.. To create and auto reply in outlook just go to rule and alert and create a rule that when you receive a message outlook reply with an email template.   That is all.

IIS VERSION

If you ask me, i think the industry need a Standardization Bureau or something. God Damn IT!  Why is it i have to struggle to find the version of IIS. You would think that you could just go to  “About Internet Information Service” in IIS manager and locate it easy but then again basic information keep changing location from one version to another.

That is why i have done a little research and compile that list below:

Windows Server 2003, you are running IIS 6.0
Windows XP, you are running IIS 5.1
Windows 2000, you are running IIS 5.0
Windows NT 4.0 or Windows 9x

<%
    response.write(Request.ServerVariables(“SERVER_SOFTWARE”))
    ‘ returns “Microsoft-IIS/4.0” for IIS 4.0 + ASP 2.0
%>

OR
 
Do a search for ASP.DLL on your system
right-click it and select Properties
Check the version tab:

IIS 3.0 shows 1.x
IIS 4.0 shows 2.x
IIS 5.0 shows 5.0.2195.x
IIS 5.1 shows 5.1.2600.x
IIS 6.0 shows 6.0.3790.x

This Script Below should give return the version of IIS you are running.