I have a lot of Excel files with VB macro that connect to IBM i.
I connect to IBM i with this string
----------------------------------------------------------------------
Function open_con()
cnMYAS400.Open "provider=IBMDA400;data source=192.001.01.99;User Id=myuid;Password=mypwd;"
Set cmMYSQLCMD.ActiveConnection = cnMYAS400
End Function
----------------------------------------------------------------------
They are stop to run on Windows 10.
The error is '3706 - provider cannot be Found. I may not be properly installed.'
Is it possible to connect to IBM i?
How to do it?
Thank you
I connect to IBM i with this string
----------------------------------------------------------------------
Function open_con()
cnMYAS400.Open "provider=IBMDA400;data source=192.001.01.99;User Id=myuid;Password=mypwd;"
Set cmMYSQLCMD.ActiveConnection = cnMYAS400
End Function
----------------------------------------------------------------------
They are stop to run on Windows 10.
The error is '3706 - provider cannot be Found. I may not be properly installed.'
Is it possible to connect to IBM i?
How to do it?
Thank you