Twitter and Pornography

Recently I have noticed a number of people trying to follow me (http://twitter/subbagiri). I was naturally flattered. My elation subsided when I clicked on the URLs to find they just had Pornographic content.

My articles on Data Access Pages

Dynamic content is at the heart of successful presentation of enterprise information on the Internet. Without the ability to present data with user interaction, Internet based commerce will be ineffective. It is possible to create dynamic web pages with data from the enterprise by using several technologies, including MS Access. Why MS Access in these days and times? Well, many businesses still use them.

Data Access Pages, a client side technology, depends on DynamicHTML. It is DHTML data binding with ADO that makes Data Access Pages possible. If you are using MS Access and attempting to place your data on the web do yourself a favor by reviewing the following articles:

Data Access Pages: What they are and how to create one ?

Using Microsoft Script Editor for Data Access Pages

Scripting a Data Access Page: a Simple Example

Creating Data Access Pages from Scratch

Creating Data Access Pages with Charts using Office Web Components

 [compare these charts to those created by MS Chart Control in ASP.NET 3.5]

Teacher's Day (September 5) in India

"The aim of education is not the acquisition of information, although important, or acquistion of technical skills, though essential in modern society, but the development of that bent of mind, that attitude of reason, that spirit of democracy which will make us responsible citizens"
Dr. S. RadhaKrishnan

President and philosopher who figured in the early years of India whose birthday is celebrated as Teacher's day

On USING SSIS to transfer data between SQL Server 2008 and MySQL

There are a large number of posts on various difficulties experienced while transferring data from MySQL using Microsoft SQL Server Integration Services. While the transfer of data from MySQL to Microsoft SQL Server 2008 is not fraught with any blocking issues, transfer of data from SQL Server 2008 to MySQL has presented various problems.


For data interchange with MySQL there are two options one of which can be accessed in the connection wizards of SQL Server Integration Services assuming you have installed the programs. The other can be used to set up a ODBC DSN as described further down. The two connection options are:

• MySQL Connector/ODBC 5.1
• Connector/Net 5.2 New versions 6.0 & 6.1

In this article we will be using the ODBC connector for MySQL which can be downloaded from the MySQL Site. The connector will be used to create an ODBC DSN. The article describes in detail how the transfer is carried out. Read on ....
this article brought to you by PACKT PUBLISHING.


MySQL Data Transfer using Sql Server Integration Services (SSIS)


Pick up the mechanics of working with SQL Server Integration 2005 under 10 days reading my no brainer book on SQL Server Integration Serivces.

Do you want to generate a Microsoft Chart chart from your Linq Data?

LINQ, short for Language Integrated Query, provides an object oriented approach to not only querying relational databases but also any kind of source such as XML, Collection of objects, etc. LINQ to SQL provides (O/R) object-relational mapping and Visual Studio 2008 IDE provides a (O/R) designer. Visual Studio 2008 also has a web server control called LinqDataSource control. This control requires a DataContext which is provided by the LINQ-to-SQL classes, a class generator that maps SQL objects to the model. Without this control one may have to generate the classes from scratch or by using the SQLMetal.exe utility which generates tables and columns.


This article brought to you by PACKT PUBLISHING shows how a table on your SQL Server 2008 can be bound to a LinqDataSource Control and then use it as the source of data for the chart. Read on...


Binding MS Chart Control to LINQ Data Source Control