Asmita's blog

Replication using custom mapping AND custom table create scripts for NON SQL subscriber - Applies to SQL server 2005 and 2008

Replication using custom mapping AND custom table create scripts for NON SQL subscriber - Applies to...

Author: asmitaw Date: 08/05/2009

How to get DB2 ServerClass and ServerVersion for your DB2 instance.

p.MsoNormal {margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in;...

Author: asmitaw Date: 07/08/2009

ADO.net provider for AS400/VSAM files in OFFLINE mode

p.MsoNormal {margin-bottom:.0001pt; font-size:10.0pt; font-family:"Times New Roman","serif";...

Author: asmitaw Date: 06/22/2009

WCF web Service - Hosting in IIS 6.0 with Windows Authentication and Web client impersonation

As we all know, Hosting a WCF service and configuring authentication is not the same as we do for...

Author: asmitaw Date: 06/15/2009

Mainframe - Printing the job(JCL) output to a file

Sometimes we want to preserve the output of jobs ( JCL ) run sucessfully so that we can refer to...

Author: asmitaw Date: 05/19/2009

Validating Image File for Content Type with ASP.NET FileUpload web control.

We use file upload web control in our sites, where we want only valid image types to be uploaded....

Author: asmitaw Date: 09/18/2008

Microsoft OLEDB provider for DB2 Service pack 2 Released

I am excited to announce that SQL 2008 compatible version of DB2OLEDB provider is available for...

Author: asmitaw Date: 09/02/2008

Asmita Wankhede - Posts Other than Host integration server

This page is to get someting here

Author: asmitaw Date: 09/02/2008

First Impressions on Google Chrome Web Browser

Just thought to write about the Chrome web browser from Microsoft Developers perspective. Browser...

Author: asmitaw Date: 09/02/2008

Sample : Executing i-series CL commands using Host file Provider - MSHostFileClient.dll

Control language (CL) REFERENCES:...

Author: asmitaw Date: 08/28/2008

There is no inspiration like this

In the month of June 2008 , I completed 2 years with "Microsoft Host Integration Server " team aka....

Author: asmitaw Date: 08/04/2008

SQL Linked server using DB2OLEDB provider

As SQL Server describes linked server in BOL (Books Online):A linked server configuration enables...

Author: asmitaw Date: 03/27/2008

Open Containing Folder in Visual Studio Solution Explorer

Hi All, After so much relaxing vacation its fun to start work considering everything as new . Yes...

Author: asmitaw Date: 01/02/2008

Managed provider for Host files - programmer's guide

New to Microsoft's Managed Provider for accessing VSAM files and AS400 file system ? Here is a...

Author: asmitaw Date: 11/01/2007

creating HCD mapping for COBOL copybook

cobol copybook : 01 DTS-LAYOUT. 05 OUT1-BOOL PIC S9(3) COMP-3. 05 OUT1-BYTE1 PIC S9(3) COMP-3. 05...

Author: asmitaw Date: 10/25/2007

BAHF - Biztalk Adapter for Host Files

Creating a BAHF Orchestration. I tried to describe the steps to create Orchestration for INSERT Send...

Author: asmitaw Date: 08/31/2007

my pledge for Green earth.

Thanks to Live earth concert ! I am sure it should have given very clear picture and messege to all...

Author: asmitaw Date: 07/09/2007

File Transfer ActiveX for Host files

Here is a sample to Transfer files to/from Host using file Transfer ActiveX control that ships with...

Author: asmitaw Date: 07/05/2007

DB2OLEDB : error messages

  1. Could not connect to data source 'ENTERPRIZE_UDL':A TCPIP socket error has occured (10061): No...

Author: asmitaw Date: 05/04/2007

DB2 Data types vs OLDB Data types

DB2 TYPE_NAME OLEDB DATA_TYPE SMALLINT DBTYPE_I2 INTEGER DBTYPE_I4 REAL DBTYPE_R4 FLOAT DBTYPE_R8...

Author: asmitaw Date: 05/04/2007

MSHostFileClient SQL syntax

SELECT Statements 1. SELECT <Column Collection> FROM Filename WHERE <Where Clause> 2....

Author: asmitaw Date: 05/02/2007

DLC error when using disabled network card

A DLC (802.2) command TRANSMIT_TEST_CMD (11H) failed with error TRANSMIT_ERROR (23H). EXPLANATION An...

Author: asmitaw Date: 04/13/2007

Fundamentals of testing

Whenever you would test anything here are the basics as per my understanding.( This is just simple...

Author: asmitaw Date: 03/13/2007

File Transfer from Windows Server to AS400

Microsft Host Integration Server's File Transfer control allows to copy / overwrite / append files...

Author: asmitaw Date: 03/05/2007

Automating SQL Server Analysis Services cubes and cubes processing

take this approach : 1. create a project ( BI Analysis Services type) 2. build this project and it...

Author: asmitaw Date: 02/20/2007

Using Single Sign On for more security

wonder how I reached SSO( single sign On).... Actually if you are very keen about the priviledges to...

Author: asmitaw Date: 02/07/2007

Inside QSAM

Q : Well someone asked me the other day can I use Host Integration Server's VSAM provider to access...

Author: asmitaw Date: 02/07/2007

Since Vista is out ....

Huh ...Huh .... and Vista is out with grand grand celebration attention all from World. I am proud...

Author: asmitaw Date: 02/07/2007

Host file Type Assemblies - Data types Mapping

For files on AS400 you may use Data type mappings like : Assembly Type Host Type A (Char) String P...

Author: asmitaw Date: 09/22/2006

using GetSchema() for columns collection in schema

GetSchema(<schema name>), using the schema mapping name of the table. e.g. try{ //Create...

Author: asmitaw Date: 09/13/2006

using GetSchema() for columns collection in schema

GetSchema(<schema name>), using the schema mapping name of the table. e.g. try{ //Create...

Author: asmitaw Date: 09/13/2006

SNA Traces while using Host file provider

You might want to use Trace tools , so that the debugging on Host side can be simulated and IDC...

Author: asmitaw Date: 09/11/2006

An internal network library error has occurred. The requested command was rejected as invalid by the target system.

Appears while using MSHostFileClient. : This error occures when SNA server IP-DLC Link service is...

Author: asmitaw Date: 09/10/2006

Using Host file provider - MsHostFileClient in HIS 2006 for VSAM and other mainframe files

Hostfile provider : Microsoft.HostIntegration.MsHostFileClient.Dll in HIS 2006 Purpose : Provide...

Author: asmitaw Date: 07/11/2006

This is my first post on Blog

This blog is exclusivly dedicated to Host integration KB and related stuff. Hang on to see more...

Author: asmitaw Date: 07/06/2006