Windows Server

MjkFinder · Guest

Dear All
I would like to know how to use HIS 2004 OLE DB Driver from DTS, I've tried
but it doesn't display any files in the DTS Wizard (Source Page) even I can’t
define the transformation, although I am already defined some VSAM file
structure under HCD .Any help or link or even white papers will be
appreciated .

Thanks & regards
I am using HIS 2004
SQL 2000
Windows 2000 Advanced Server

eb · Guest

I am trying to achieve something similar, but failing to establish a
connection with the mainframe at this stage. I installed the HIS 2004 client
on a workstation, which lists OLE DB provider for AS400 and VSAM. Is this
enough for establishing a connection with mainframe?

"MjkFinder" wrote:

Neil Pike · Guest

Mjk,

Not a feature of HIS I've used. In the first instance can you do a network
trace to see if any packets are being sent to the mainframe and whether the
mainframe is replying at all?

If you're not au fait with network traces feel free to zip them and email them
to me. Or stick on an FTP/WEB site and post a link here.

Neil Pike. Protech Computing Ltd
Microsoft SNA/HIS MVP

MjkFinder · Guest

not enough, you have to do some other sitting on mainframe, see the
documentation and consolidate your mainframe system engineer .
for the windows side I think its enough, but it depend on how did u
installed the HIS.
I am already did the connection and i am now able to retrieve the data from
mainframe VSAM files using my own created tool .
ask me if you have any more questions ?
Regards

"eb" wrote:

MjkFinder · Guest

Thanks for your reply
I have already did the connection and i am now able to retrieve the data
from mainframe VSAM files using my own created tool .
the problem is ' i want to use DTS as mentioned in the documentation for
ETL(Extract Transform and Load) the data from VSAM to SQL Server instead of
My Tool.
I am using with DTS the same Data Source and HCD which I've already created
and using with my tool (VB.NET Appl.) .
in DTS source Page Wizard I have connection tested successfully but when
click dropdown list i didn’t find any files (which already defined under HCD
)
from trace point of view every thing is alright ... :(o
any help will be appreciated
Regards

"Neil Pike" wrote:

Neil Pike · Guest

Mjk,

Assuming you're doing the DTS on the same box, with the same userid, that you're
able to use your own tool on, then that rules out any driver/connection issues I
guess.

Only thing I can think of is some sort of SQL/DTS compatibility issue - I assume
you're using SQL 2000's DTS?

If one of the MS folks aren't able to jump in here with an obvious gotcha then
you'll need to open a case with MS PSS.

SNAOLEDB support access to VSAM data sets from SQL Server DT

	Windows Server Forum Index -> Host Integration Server	All times are GMT
Page 1 of 1