RE:Acceder desde pc a libreria de AS400
En ADO
Private conexion_192_168_xxx_xxx As New ADODB.Connection
Private CONEXION_LECTURA_ESCRITURA As New ADODB.Command
Private registros As New ADODB.Recordset
Private registro1 As New ADODB.Recordset
Private xqry As String
Dim FOR1 As Integer
Dim FOR2 As Integer
Dim FOR3 As Integer
'variable para excel
Private hoja_excel As Object
Private LINEA As Integer
Private LINEA_INICIO As Integer
Private COLUMNA As Integer
Option Explicit
Private Sub Form_Load()
'-------------------
'CONECTAR CON BASE DE DATOS
'-------------------
conexion_192_168_xxx_xxx.Open "Provider=IBMDA400;Data Source=192.168.xxx.xxx;", "usuario", "contraseña"
Set CONEXION_LECTURA_ESCRITURA.ActiveConnection = conexion_192_168_xxx_xxx
End sub
==============================================================
ODBC
Option Explicit
Private CONEXION_LECTURA_ESCRITURA As rdoConnection
Private ENTORNO_LECTURA_ESCRITURA As rdoEnvironment
Private RESULTADO As rdoResultset
Private xqry As String
Private PR_sentencia As String
Private PR_usuario As String
Private Sub contraseña_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Call F10_Click
End If
End Sub
Private Sub F10_Click()
PR_sentencia = "UID=" & usuario_programa & ";PWD=" & contraseña & ";"
'-------------------
'CONECTAR CON BASE DE DATOS
'-------------------
Set ENTORNO_LECTURA_ESCRITURA = rdoEngine.rdoCreateEnvironment("", "", "")
Set CONEXION_LECTURA_ESCRITURA = ENTORNO_LECTURA_ESCRITURA.OpenConnection(DSNAME:="AS400", Prompt:=rdDriverCompleteRequired, Connect:=PR_sentencia)
ENDSUB
==============================================================
FTP
Fichero bat
Echo off
Cls
ftp –s c:fichero.txt 192.168.xxx.xxx
cls
exit
fichero txt
usario
contraseña
put c:carpeta_pcfichero_pc /qdls/mi_carpeta_en_as400/fichero_pc
quit