I am a new programmer on the iSeries 400 and VB -- I am working in systems management. I tried to connect the iSeries...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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).
Dig Deeper on Performance
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.