.NET data provider and AS400

eXavier

unread,

Jun 21, 2004, 5:38:25 AM6/21/04

to

Hello,
I would like to ask on .NET data provider for DB2, specifically I need to
connect to AS400.
First I'd like to know if there is a release date of data provider
specified.

I have an application which needs to read/write some data to DB2 on AS/400
(there is V5R2M0 version installed). I would like to use managed provider.
I downloaded Stinger last Thuersday and started with installation DB2
Connect from it. Because it added also components to Visual Studio.NET I
expect the data provider is also installed. Or do I need also to install
APPDEV (Application development client) ?

I started Configuration Assitent and added database using wizard. (according
to contribution by Claus Samuelson in this newsgroup from April 27) Only
Test Connection feature doesn't work to me, If I choose it from within
context menu or 'Selected' menu, nothing happens. I tried also 'Bind',
'Change Password', 'CLI Settings', but these actions are probably not
implemented yet. Even 'Remove database' action does nothing.
During adding database I left checked creation of ODBC source, I tested the
ODBC connection and it works correctly.

So I opened Control Center and tried the connection, I was able to receive
list of tables on target system. I noticed that there are no action in
'Selected' menu for a table. Is this specific for AS400 database? I remember
that for local database it was possible to retrive rows from table and there
were several actions on table. Also I tried 'Setup Communication' and
received error about DB2 Administration Server on target machine. Is there
such server on AS400? (I'm definitely not AS400 guy) Is it standard part of
AS400 system or can it be installed on AS400?

Then I opened Visual Studio and started DB2DatabaseProject. When adding data
connection I received SQL30081N ... IBM.Data.DB2: 08001 error. I found
follwing error in output window: 'Error occurred during discovery of
databases'.

Could anyone help me to find what is wrong or give me some advice, please?
Thanks,
eXavier

eXavier

unread,

Jun 21, 2004, 10:32:58 AM6/21/04

to

Now I am able to connect!
Previously, I always changed Server in Connection tab of 'Add new
connection' in VS.NET to server name (IP) to which I wanted to connect to.
Last I left it to localhost and it works now. How easy... I only
misunderstood meaning of Server...

"eXavier" wrote in message news:cb6aai$830e$1...@news.boulder.ibm.com...

sv...@svi.com.mx

unread,

Feb 13, 2006, 1:42:48 PM2/13/06

to

Somebody can help me?

The PC an the AS/400 are local.

I'm not sure about what IBM LIC PGM do I need to install in the AS/400.

I'm using OS/400 V5R2M0.

Thank you in advance.

RENE GARCIA

sanka...@wipro.com

unread,

Nov 8, 2006, 1:18:28 PM11/8/06

to

Hi

Im actually trying to connect to DB2 in iSeries and using DB2 .NET Data Provider's iDB2Connection class. There is some problem in the connection string or some other issue. I get below error;

Error:
"A communication error occurred." System.Exception { IBM.Data.DB2.iSeries.iDB2CommErrorException }

Connection String: string strCon = "DataSource=CCSSY2DTA;User ID=CCSSY1BLT;Password=SYSBU113T1;Database=CCSSY2DTA";

Kindly help me out.

Tx & Regards
Jinishans

lla...@us.ibm.com

unread,

Mar 2, 2007, 5:59:51 PM3/2/07

to

Here's a good source of information. This redbook covers both IBM managed providers.
http://www.redbooks.ibm.com/abstracts/sg246440.html?Open