AS 400

[Guest]

I am trying to connect to as400 using oledbconnection
the connection is opened but when i try to retreive data i get an error
message
cn = New OleDb.OleDbConnection(StrAS400)

cn.Open()

cmd = New OleDb.OleDbCommand(StrSql, cn)


dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
StrAS400 is the connection string
Provider=IBMDA400;Data Source=xxxxxx;User Id=xxxxx;Password=xxxxxx;

Can anybody help me?

 

[Frans Bouma [C# MVP]]

I am trying to connect to as400 using oledbconnection
the connection is opened but when i try to retreive data i get an
error message
cn = New OleDb.OleDbConnection(StrAS400)

cn.Open()

cmd = New OleDb.OleDbCommand(StrSql, cn)


dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
StrAS400 is the connection string
Provider=IBMDA400;Data Source=xxxxxx;User Id=xxxxx;Password=xxxxxx;

Can anybody help me?

Let's start by posting the error message, and if available, the
exception stacktrace.

I also would recommend the ADO.NET provider for eSeries, available in
the latest Client Access client software from IBM.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------