.net apps with AS400

I currently connect to our AS400 via the iDB2Connection, but I have to write it out, I would like to be able to connect so I can use the wizards, like I do against out SQL server.  I've tried several things,  I installed the toolkit from Client Access V5R4, I've downloaded DB2 connect and installed it on my local machine to no avail.  Can anyone tell me what I need to have installed to connect to the AS400?  My system is XP pro, Client Access V5R4, Visual Studio Pro 2005.  AS400, DB2 is not installed.  If I left something out please ask.  Thanks
LVL 2
bergertimeAsked:
Who is Participating?
 
daveslaterConnect With a Mentor Commented:
You can use ADO or ODBC to connect via .Net
if you want to develop in .net ASNA do an RPG.NET connection

http://www.asna.com/index/Products/VisualRPG/

Post back with how you see it progressing

Dave

0
 
egtebertConnect With a Mentor Commented:
Hi,
Here is a methode to get it done:
http://www.codeprof.com/dev-archive/17/12-45-173364.shtm
(Method to connect to AS400 via IDB2.Net Provider or Oledb)

For some coding exemple:
http://www.codeprof.com/dev-archive/147/12-45-1470039.shtm
good luck
0
 
bergertimeAuthor Commented:
Here is the connection string I use: (pretty much the same as what egtebert posted)

Dim cn As iDB2Connection = New iDB2Connection("User =me;Password=me;Data Source=10.1.1.1;Connection Timeout = 0")
Dim cmd As iDB2Command

It all works fine if I hand code it.......but I want to use the iDB2 .NetProvider (based on ADO.net I guess) to connect so I can see my tables in server explorer in visual studio, like I can with SQL server or when I connect using ODBC to the iSeries.    Thanks for the links, sorry if I'm not real clear on this but I'm not real clear on the AS400.  
0
 
daveslaterCommented:
Hi
you can use iSeries navigator for that.

it is under start/programs/ibm iSeries access .....

Dave
0
 
bergertimeAuthor Commented:
OK, I'm installing all the options under navigator, I was always under the impression it was like Enterprise Manager for SQL Server.  Thanks for your help.
0
All Courses

From novice to tech pro — start learning today.