MFC with AS400 backEnd.....
Posted on 2002-06-02
I have a bunch of MBR files (say 20 with 20,000 records/page) in an AS400 server. These *.mbr files are generated every day by some other programs and are names XXX0224.mbr, with last 4 bits of file names as date.
These MBR files represent the data that I am supposed to work with. My client program is in VC++ and will reside in another server(windows ) from the data (AS400).
This VC++ /MFC client program is to work on AS400 server's data (mbr files) which somewhat look to me like text files on that system. ( I am new to AS400, never used it before). A lot of these files data are itself not in a standard format to make things worse.
1) How do I attack this problem?
a)How do I connect to the AS400 mbr data files from a windows client (VC++/MFC).The window system I am developing on can see the AS400 server in the Network Neighbourhood.
I read some articles suggesting the use of third party drivers like Star ODBC, RUMBA etc.
Where are these available to download and try out?
And say I am able to make an ODBC connectivity somehow , how do I connect to the dynamically changing files for each day.
I need As much info as possible, possible problems I may face and tips as possible.
Thanks a lot