On Aug 22, 7:25 am, "Charles Ezzell \(MSFT\)"
Post by Charles Ezzell (MSFT)What is in your UDL? What, if any, errors come back when you do the sample
query? And, can you create packages?
Your UDL should be something similar this (depending on the version of HIS
Provider=DB2OLEDB;User ID=XXXX;Password=XXXX;Initial
Catalog=S105FRDM;Network Transport Library=TCP;Host CCSID=37;PC Code
Page=1252;Network Address=172.29.136.200;Network Port=446;Package
Collection=CHARLIEE;Default Schema=CHARLIEE;Process Binary as
Character=False;Units of Work=RUW;Default Qualifier=CHARLIEE;DBMS
Platform=DB2/AS400;Defer Prepare=False;Rowset Cache Size=0;Persist Security
Info=True;Connection Pooling=False;Derive Parameters=False;
--
HTH,
Charles Ezzell
Microsoft Host Integration Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm. Any and all views expressed are
those of the writer and not Microsoft. There is no such thing as a free
lunch. Peach is not a color. Violets are not blue.
Post by Steve Richterusing HIS to connect to as400.
I successfully created a data source under db2 ole db udl in the data
sources tree. Problem is when I run the sample query I get nothing. Is
that ok?
type: tcp/ip
platform: db2/as400
initial catalog: my as400 system name. also, the *local entry in
wrkrdbdire.
package collection: steve1 ( a library on my as400 )
default schema: steve1 ( my library steve1 has some database files )
default qualifier: steve1
security method: interactive signon
connection pooling: checked
Successfully connected to data source 's104vdnm'.
Server class: DB2/400
Server version: 05.01.0000
thanks,
-Steve- Hide quoted text -
- Show quoted text -
tried as qsecofr with same results. sample query does not show any
tables.
can you tell me the name of the server job on the as400 that runs the
remote database requests? I checked the joblog of all the server jobs
and did not see anything.
created a library called HISTEST. gave *public *all authority.
HISTEST contains one physical file named WUSLINE. When I use STRSQL
and then "select * from histest/wusline", there are rows in the
table.
my connection string:
Provider=DB2OLEDB;User ID=xxxx;Password=xxxx;Initial
Catalog=s104vdnm;Network Transport Library=TCP;Host CCSID=37;PC Code
Page=1252;Network Address=10.10.10.160;Network Port=446;Package
Collection=histest;Default Schema=histest;Process Binary as
Character=False;Units of Work=RUW;Default Qualifier=histest;DBMS
Platform=DB2/AS400;Defer Prepare=False;Rowset Cache Size=0;Persist
Security Info=True;Connection Pooling=False;Derive Parameters=False;
a package collection was created:
Work with Objects Using PDM
Library . . . . . HISTEST Position to . . . . . . . .
Position to type . . . . .
Type options, press Enter.
2=Change 3=Copy 4=Delete 5=Display 7=Rename
8=Display description 9=Save 10=Restore 11=Move ..
Opt Object Type Attribute Text
MSCS001 *SQLPKG PACKAGE
MSNC001 *SQLPKG PACKAGE
MSRR001 *SQLPKG PACKAGE
MSRS001 *SQLPKG PACKAGE
MSUR001 *SQLPKG PACKAGE
here is my wrkrdbdire output:
Work with Relational Database Directory
Entries
Type options, press
Enter.
1=Add 2=Change 4=Remove 5=Display details 6=Print
details
Relational
Remote
Option Database Location
Text
S104VDNM *LOCAL Entry added by
system