I am a new programmer on the iSeries 400 and VB -- I am working in systems management. I tried to connect the iSeries 400 via ADO. But I can't do this without DSN connections. I want to use OLE DB Provider for the iSeries to connect to the iSeries databases. Can you send me examples?
Here is a small VBA example using the AS/400 OLE DB provider to connect via ADO and not via DSN):
Set Conn = New ADODB.Connection'
Conn.Open "Provider=IBMDA400;Data Source=SYSTEM;" _
Please note that the provider is IBMDA400 (not MSDASQL).
This was first published in March 2001