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.
View 3 RepliesI 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?
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()
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)