Hodentek

Saturday, February 28, 2009

Error Code -1071610801 in Integration Services 2008 found

I came across this error code while using integration services for a Data Flow Task. I wonder if any one else has come across this. The ADO.NET Destination component does not provide a description for this. It is not listed in the DTS error code on MSDN.

Added: March 3, 2009

According to a reliable MS Source Phil Brammer
The above code refers to:

DTS_E_ADODESTERRORUPDATEROW

Thursday, February 26, 2009

How to add a web slice to your page?

First of all, Web Slice is new stuff in IE8, RC1. This serves similar function as an RSS feed.

This is quite easy to implement in your web pages.

Let us start with our first step.
This is a page on my intranet server. A very simple page that has a Jquery
script embedded in it.
==========
H1SelectorJQry_noslice.htm
==========

<html>
<head></head>
<body>
<script language="JavaScript" src="http://localhost/JayQuery/jquery-1.3.min.js">
</script>

<h1>Jquery inside a DOJO Accordion Pane</h1>
<div>
<p style="color:red; font-weight:bold">You Want More Dojo and JQuery Articles</p>
<div>
Add this slice
</div>
<div>
<script type="text/JavaScript">
$(document).ready(function(){
$("h1").css("color", "magenta");});
</script>
</body>
</html>
==============
If you open this in IE8 RC1 this is what you will see.

Now modify the code as shown. Note particlularly the css elements added. I call this modified page,

========================

H1SelectorJQry-Slice.htm

========================
<html>
<head></head>
<body>
<script language="JavaScript"
src="http://localhost/JayQuery/jquery-1.3.min.js">
</script>
<h1>Jquery inside a DOJO Accordion Pane</h1>
<div class="hslice" id="mySlice" >
<p class="entry-title" style="color:red; font-weight:bold">
You Want More Dojo and JQuery Articles</p>
<div class="entry-content">

Add this slice

</div>
<div>
<script type="text/JavaScript">
$(document).ready(function(){
$("h1").css("color", "magenta");});
</script>
</body>
</html>

============

With this modification the web page hosted on my intranet server looks like this when you browse the page.
When IE8.0 RC1 encounters "hslice" it knows what to do with it.

Now when you (or someone who looks up this page) click on the green icon, you (he) will see this displayed

If you are interested in watching this page whenever I update this page, then an icon will be added as shown to the favourites bar (if you so wish in the previous screen) as shown here inside the red square.

There is really nothing much to it, is it? This is cool stuff.

Monday, February 23, 2009

Added Live Search to my Tilt

I added Live Search to my handheld Tilt. I had to repair my ActiveSync before I could do this. Look up this post in my other blog for details.

http://hodentekmobile.blogspot.com/2009/02/live-search-for-windows-mobile-6.html

Tuesday, February 17, 2009

Data Access Pages (MS Access 2003) does not show up in IE8.0 RC1

When you save your data access pages to your intranet site, the page may not show and you will have to tune your security settings of IE 8.0 to see pages correctly.

Follow this procedure:
It is assumed that you haev down loaded the owc.exe from Microsoft site. It is also assumed that you have a
DAC which shows up correctly in Page View.

In order to access the data contained within the Data Access Page, you need to:

1. Start IE
2. Choose Internet Options from the Tools menu
3. Click on the "Security" Tab
4. Click on the "Trusted Sites" icon
5. Click on the "Sites..." button
6. Uncheck the "Require server verification (https) for all sites in the zone" checkbox
7. You then add your site on which you have hosted the page as a trusted server.

Now you have a better chance of seeing the page.