P
Paul Koufalis
Guest
OpenEdge DataServer for MS SQL: This makes the MS SQL database look like an OpenEdge database to your 4GL code. All you have to do is "FOR EACH ...". This is a separate product that you have to purchase. For simple stuff, there are some new ODBC classes in the language that you can use to make a direct ODBC connection from your 4GL code to an ODBC datasource. This is a little more complex and inflexible but it's free. Third option: you can use MS SQL Integration Services as the client connecting to the OpenEdge DB via ODBC. This is if you need to push and pull data between the two databases and don't require access to MSSQL from the user.
Continue reading...
Continue reading...