I'm running the MAS 200 4.10.1.1 client. I want to write a Java app to query the MAS database directly via ODBC (I don't want to use VI or MS Query to write to an Excel spreadsheet, for instance). How do I do this?
DB connection and access will be slow. A possible solution is to have a secondary, faster db, but then you'll have to deal with the issue of keeping that second db in sync with the first. You could use the secondary db to just hold the more highly accessed data.
I don't want to use VI or MS Query to write to an Excel spreadsheet, for instance"
Using Vi to export data is not a good idea. Extremly slow. However MS Query pulling data into Excel is fast and easy and is widely used. Pulling into Access with SQL Specific Pass Through Queries is another fast and simple method.
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.