Windows Server

Olivier Matrot · Guest

Hello,

I have problems with the IBM DB2 OLE DB Provider.
I'm trying to use the MS DB2 OLE DB Provider.
DB2-UDB 8.2 Express/NT is installed on my computer (XPSP2).
Can I use and configure the HIS Client alone or should I install HIS Server
?
TIA.

Aaron Grady [MSFT] · Guest

Olivier-

Yes, the Microsoft Ole DB provider for DB2 (and our .NET managed provider
for DB2) come with the HIS 2004 client installation. You can install and use
just this piece on your system, but do keep in mind that you still need to
have a valid HIS server license to use this.

I would recommend that you download the eval version of HIS and test it out
on your system to see if it works for you:
http://www.microsoft.com/hiserver/evaluation/trial/default.mspx

Or... if you're an MSDN subscriber, the developer edition of HIS should come
on your MSDN CDs/DVDs

HTH,
--
Aaron Grady
MCSE + Internet, MCDBA, MCSD, MCAD.NET
SNA Server/Host Integration Server
Microsoft

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Olivier Matrot" <olivier.matrot.rte@online.nospam> wrote in message
news:%233EcKLkgFHA.3868@TK2MSFTNGP14.phx.gbl...

Olivier Matrot · Guest

Ok thanks for that.

"Aaron Grady [MSFT]" <aagrady@online.microsoft.com> wrote in message
news:%23GqY2MlgFHA.1148@TK2MSFTNGP12.phx.gbl...

Olivier Matrot · Guest

Can someone point me to some documentation that precisely describe what is
supported with this provider ?
DBPROP_IRowsetChange supported ? IDENTITY columns and
DBPROP_SERVERDATAONINSERT rowset property ?

I'm unable to insert data in a table that contains an identity column.
I'm able to reproduce the error using a simple table and OLEDB RowsetViewer
from MDAC SDK. The problem occurs whenever an IDENTITY column is included in
the rowset. If it's not the case, everything works fine.

Here are the steps :

1) Create a table in a db2 database with the folowing DDL.

CREATE TABLE DBO.TEST
(
IDRECORD INTEGER GENERATED ALWAYS AS IDENTITY ( START WITH 1, INCREMENT BY
1, NO CYCLE, MINVALUE 1, MAXVALUE 2147483647, NO CACHE ),
VAL INTEGER NOT NULL
)
IN USERSPACE1

2) Launch "rowset viewer"

3) Select File/Data Links from menu. Cancel the 'Data Link Properties'
dialog.

4) Right click the Data Links node in Objects window, choose
IDBPromptInitialize/Prompt File Name...

5) Browse to an UDL file that connects to the database and choose [Open]

6) In the 'Command Window' enter the following select Statement : "SELECT
IDRECORD,VAL FROM DBO.TEST"

7) Right click on Command node in Objects window and select Icommand/Execute

8) Veriy that IID_Irowset is selected in REFIID option, SetCommandText is
checked and click [OK]

9) Right click the node 'Rowset'in Objects window, choose
IRowsetChange/InsertRow

10) In the following Window make sure that the Status for column IDRECORD is
set to DBSTATUS_S_IGNORE (right click status)

11) Enter a value in VAL data and click [InsertRow]

12) Check the error window that follows.

TIA.

"Olivier Matrot" <olivier.matrot.rte@online.nospam> wrote in message
news:e374g4sgFHA.1372@TK2MSFTNGP10.phx.gbl...

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