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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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).
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.