Has anyone connected Visual Cobol running on AIX to SQL Server

We have a large number of  Cobol jobs running on AIX that connect to a Sybase database.  Our company is migrating that database over to SQL Server so we'd like to pick the best migration path for these Cobol jobs.  So far, we're looing at two options:

1. Use an 3rd-party ODBC driver.  Is anyone doing this?  If so, what driver are you using and what advice do you have?  We're not sure which driver to use (Microsoft does not provide an ODBC driver for AIX).  We're an enterprise company so we need driver software which is supported (e.g. - by a vendor).

2. Compile all of our Cobol jobs as Java and then use a JDBC driver (which Microsoft does provide).  In this case, we're worried about the impact this would have on our AIX server.  If we convert all of these jobs to java, will that result in higher memory or CPU demands on the box?  Are there any other things to watch out for?

Parents
  • SUCCESS!  We used Easysoft, which comes with an  ODBC manager (unixOdbc).  We installed it onto our test AIX box and configured the odbci.ini file (I think that's the name of the file!) to point to our SQL Server instance.  Once that was done, we built a Visual Cobol compile script (using Korn shell) and referenced the odbc instance that we just configured in the odbc file.  Note that newer versions of Easysoft support TLS 1.2 as well.

Reply
  • SUCCESS!  We used Easysoft, which comes with an  ODBC manager (unixOdbc).  We installed it onto our test AIX box and configured the odbci.ini file (I think that's the name of the file!) to point to our SQL Server instance.  Once that was done, we built a Visual Cobol compile script (using Korn shell) and referenced the odbc instance that we just configured in the odbc file.  Note that newer versions of Easysoft support TLS 1.2 as well.

Children
No Data