HI.. anyone had working with DB conection to AS400?

[jlizardo]

HI.. Anyone had working with DB conection to AS400 using VB.NET?. This is a really important question becouse i'm starting develop some project with that feature.. Thank Johnny Lizardo.

[magnus__lindberg]

But yes ofcourse. There's no problems what I have seen. I'm working with an IBM DB2 database, with the ODBC driver "Client Access ODBC Driver" Hope my reply gave you all the answers you wanted. herher /Magnus

[jlizardo]

Hi Thank for your fast reponse. Look, This is my first time to try this with AS400.. For now I want the simple code to connection to any database. Otherthing, only I need is the Client Access ODBC Driver for connection? Thank a lot. Johnny Lizardo

[Paul Farry]

Hi, On your client access install you should find the OLEDB provider for AS400. This is a much faster library to be using for accessing the AS400, rather than ODBC. I'm currently at home so I don't have the exact connect string. But it's the Provider=IBMDA400 I'll post the proper connection string in the morning, then is also a little trick to setting up the Client Access Install, so that you can pass through your Username/Password in the Connection string rather than having client access popup a Dialog asking for the username etc. CWBCFG or similar to that once again ... in the morning...

[jlizardo]

Hi Thank for your help. The bad news is my client don't have client access to link to AS400, they have Rumba. The good news is I download a evaluation copy from Hit OLEDB400 (www.hit.com) And now this connection works. Thank everyone for your support. Johnny Lizardo