FTP From .net To AS400?

Jan 18, 2010

I am looking to FTP right from my VB.net exe a file to the IBM AS400.  I would prefer not using third party utilities.  Is this possible.  I know I can write a BAT file to do this but really was looking to do this within the program.  The IP address of the 400 is known and also the pc file name.

ADVERTISEMENT

Connecting To AS400 Remotely?

Feb 22, 2010

I need to connect to AS/400 remotely from VB.net I have this code but I keep getting this error "The 'IBMDA400' provider is not registered on the local machine"  on the open statement 

Dim conString As String = "Provider=IBMDA400;Data source=62.176.136.104;User Id=xxxxxxx;Password=*****"
Dim con As OleDbConnection = New OleDbConnection(conString)
Dim cmd As OleDbCommand = New OleDbCommand("Select * From Cust", con)
 con.Open()

How do I get around this?

View 1 Replies View Related

ISSUES Writing To AS400 Via ODBC?

Jan 7, 2011

What am I doing wrong? I can write NUMBERS into the AS400 table but when the values are STRINGS, it craps out.

Dim dataCON As New OdbcConnection("DSN=XXX;SYSTEM=XXX;UID=AS400;Password=XXX;DBQ=XXXXXX")

Dim SQLCommand As String SQLCommand = "INSERT INTO ICPICK (PDTYPE,PDSEQ#,PDDATA) VALUES(" & SplitStringRow(0) & "," & SplitStringRow(1) & SplitStringRow(2) & ")"dataCON.Open()Dim dataCMD As New OdbcCommand(SQLCommand, dataCON) dataCMD.ExecuteNonQuery()dataCON.Close()

View 6 Replies View Related

Check File Exists On AS400 Server Using Winform Application?

Dec 9, 2009

I am working on a Windows Application where i need to check a file exists in particular library with user crediantials.

Note : .Net framework 1.1 (VS2003)

View 4 Replies View Related

ADVERTISEMENT