Re: AS/400 SQL Access to Databases -- C400-L

Subject: Re: [C400-L] AS/400 SQL Access to Databases
From: Scott Klement <c400-l@xxxxxxxxxxxxxxxx>
Date: Thu, 24 Mar 2005 17:39:50 -0600 (CST)
List-archive: <http://archive.midrange.com/c400-l>
List-help: <mailto:c400-l-request@midrange.com?subject=help>
List-id: C programming iSeries / AS400 <c400-l.midrange.com>
List-post: <mailto:c400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/c400-l>, <mailto:c400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/c400-l>, <mailto:c400-l-request@midrange.com?subject=unsubscribe>

Hi Etienne,

I am looking for a product that will allow me to access other databases
using SQL in ILE C++ programs.

Other Databases:
* MS SQL Server
* Oracle
* MySQL
* Etc.

I know that John Brandt was working on something like this (though, I don't know if it supports anything besides MS SQL server). You might check out his home page: http://www.istudio400.com

Otherwise, there's JDBC in Java... it should be able to access any of those databases. You could write some JNI code to invoke the Java routines from C.... throw that in a service program to make it easy for your other programs. This probably won't perform very well, but that's Java for you.

Good Luck

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].