There’s another way to do this
1. - create a user in As400 just for connection
2. - create a link server in SQL
4. - and then connect to the as400 to retrieve the data and update the table you need. (Open query)
If you need more detail please let me know.
Best regards.
How can prevent from people with ODBC access in AS400 to UPDATE or INSERT data in the data base, We give them access to download data to EXEL and some to retrieve data with FOX, from the server, but some are installing Access DB from Microsoft and if they have access to ODBC I can’t restrict...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.