RE:VB-ADO conectar con AS/400
PRUEBA CON ESTE CODIGO
xSysName = oSistema 'Nombre de tu Sistema AS400
xUser = oUsuario 'Usuario
xPass = oPassword 'Password
Public cnAs400 As ADODB.Connection
Set cnAs400 = New ADODB.Connection
cnAs400.Open "Provider=IBMDA400;Data Source=" & Trim(xSysName) & ";", Trim(xUser), Trim(xPass)
Para conectarte a una tabla
Dim rs As ADODB.Recordset
Screen.MousePointer = vbHourglass
sql = "SELECT * FROM LIBRERIA.TABLA"
Set rs = New ADODB.Recordset
Set rs.ActiveConnection = cnAs400
With rs
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic (SELECCIONA EL TIPO)
.Open sql, cnAs400
End With
Saludos Lima - Perú