AS 400

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
MaryA said:
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?
Click to expand...

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#)
------------------------------------------------------------------------
 
Back
Top