IBM.Data.DB2.iSeries database access problem

Yanik Reid · *nix forums beginner Joined: 13 Feb 2005 Posts: 1

When I run the following vb.net code, I'm not able to acces the my database
AMFLIB.

I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries
Access but now I want to use the new managed IBM.Data.DB2.iSeries data
provider from iSeries Access V5R3.

When I remove Database=AMFLIB from the connection string, I can connect but
as soon as I try to specify a known database (like my good old AMFLIB) I get
the following error:

IBM.Data.DB2.iSeries.iDB2ConnectionFailedException
"The connection cannot be opened because an error ocurred."

I'm running IBM iSeries Access V5R3 and my server is V5R2.

When I don't specify a database, after the connection is open the database
property is set to AS400REM. I don't know if this database is a real
database specific to my company.

******************************************
Imports IBM.Data.DB2.iSeries

Dim cn As New iDB2Connection

Try
TestConnection.ConnectionString = _
"DataSource=AS400;UserID=xxxx;Password=xxxx;Database=AMFLIB"

TestConnection.Open()
If TestConnection.State = ConnectionState.Open Then
MsgBox("Database: " & TestConnection.Database)
TestConnection.Close()
End If
Catch ex As Exception
MsgBox(ex.Message)
End Try
******************************************

Thanks to all

Karl Hanson · *nix forums beginner Joined: 19 Jul 2005 Posts: 29

Yanik Reid wrote:

Google