Replication using custom mapping AND custom table create scripts for NON SQL subscriber - Applies to SQL server 2005 and 2008 The purpose of this document is to demonstrate how SQL Server replication can be directed to use custom mapping while copying...

here is code snippet using DataAccessLibrary that ships with : 1. Microsoft Host Integration Server AND 2. Microsoft Biztalk Adapters for Host Systems AND 3. Microsoft's DB2OLEDB (SQL server feature pack for DB2 ) . if you have any of these...

Just thought of writing a quick post on this new feature that ships with HIS 2009. To give some introduction about this provider - HIS 2006 ships with first version of ADO.net provider for mainframe and AS400 files systems. At the time product required...

As we all know, Hosting a WCF service and configuring authentication is not the same as we do for ASMX. There are many changes and the way we get credentials in service code and on server etc. I am not going to get deep into it, THIS LINK however here...

Sometimes we want to preserve the output of jobs ( JCL ) run sucessfully so that we can refer to them in future. The way I like to use these results is to convince my mainframe Admin that I am referring to the correct environment settings and the job...

We use file upload web control in our sites, where we want only valid image types to be uploaded. Without talking much -> here are 3 ways to do it. 1. Accept attribute of fileUpload control - Doesnt work with most of the browsers (Bad with IE...

I am excited to announce that SQL 2008 compatible version of DB2OLEDB provider is available for download at : http://www.microsoft.com/downloads/details.aspx?FamilyID=c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c&DisplayLang=en This provider supports...

Just thought to write about the Chrome web browser from Microsoft Developers perspective. Browser can be downloaded from http://www.google.com/chrome 1. Silver light is not Supported (No Silverlight to start with) 2. Ajax toolkit project will...

Control language (CL) REFERENCES: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rbam6/rbam6clmain.htm C# sample : using System; using System.Collections.Generic; using System.Text; using Microsoft.HostIntegration...

In the month of June 2008 , I completed 2 years with "Microsoft Host Integration Server " team aka. HIS . I wrote very few blogs. I hope some of them helped some HIS community out there. Whenever I write something on this medium of blog , I consider...

As SQL Server describes linked server in BOL (Books Online): A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages: Remote server access...

Hi All, After so much relaxing vacation its fun to start work considering everything as new . Yes its new year and so I am starting everything as if I am doing it fresh , the first time. With thatmuch curiously and Interest. So I started the work...

Oslo is annouced to the technical community in SOA conference in OCT 2007 here in campus. What is OSLO ? People came from accross the world to Redmond, WA to attend the SOA Conference .I met someone from my home country in the conference and the...

New to Microsoft's Managed Provider for accessing VSAM files and AS400 file system ? Here is a compile of material that can be helpful for the first time users : Product documentation for programmers: http://msdn2.microsoft.com/en-us/library...

cobol copybook : 01 DTS-LAYOUT. 05 OUT1-BOOL PIC S9(3) COMP-3. 05 OUT1-BYTE1 PIC S9(3) COMP-3. 05 OUT1-DATE1 PIC X(10). 05 OUT1-DECIMAL1 PIC S9(15)V9(03). 05 OUT1-DECIMAL2 PIC S9(15)V9(03). 05 OUT1-DOUBLE1 COMP-2. 05 OUT1-DOUBLE2 PIC S9(09)V9(09)....

Creating a BAHF Orchestration. I tried to describe the steps to create Orchestration for INSERT Send Port . I wpuld try to describe more in the upcomming posts.

Thanks to Live earth concert ! I am sure it should have given very clear picture and messege to all viewers ! I feel I can fight against global warming by doing simple things : 1. avoid taking car for short distance 2. carpool whenever possible...

Here is a sample to Transfer files to/from Host using file Transfer ActiveX control that ships with " Microsoft Host Integration Server" : its needs reference to MSEIGFTLib.dll from C:\Program Files\Microsoft Host Integration Server\system\MSEIGFTLib...

1. Could not connect to data source 'ENTERPRIZE_UDL': A TCPIP socket error has occured (10061): No connection could be made because the target machine actively refused it. SQLSTATE: 08S01, SQLCODE: 10061 you get this error message when a) PORT Number...

DB2 TYPE_NAME OLEDB DATA_TYPE SMALLINT DBTYPE_I2 INTEGER DBTYPE_I4 REAL DBTYPE_R4 FLOAT DBTYPE_R8 DOUBLE DBTYPE_R8 DECIMAL DBTYPE_DECIMAL GRAPHIC...

SELECT Statements 1. SELECT <Column Collection> FROM Filename WHERE <Where Clause> 2. SELECT <Column Collection> FROM Filename AS <AssemblyName.SchemaName> WHERE <Where Clause> Details of Column Collection...

A DLC (802.2) command TRANSMIT_TEST_CMD (11H) failed with error TRANSMIT_ERROR (23H). EXPLANATION An error code which is not explicitly handled by Host Integration Server has been returned by the DLC driver. This could be due to network card...

Whenever you would test anything here are the basics as per my understanding.( This is just simple Vanilla explaination in my words of whole theory of testing) 1. Test the product to see it works - Acceptance testing. 2. Test to see it works as...

Microsft Host Integration Server's File Transfer control allows to copy / overwrite / append files to and from AS/400 , Mainframe and AS/36 Samples can be found at : C:\Program Files\Microsoft Host Integration Server 2006\SDK\Samples\DataIntegration...

take this approach : 1. create a project ( BI Analysis Services type) 2. build this project and it will create the asdatabase file. 3.Automate cubes deploy : Deploy the asdatabse file with /s options on command line : command line for it is...