Long Shot

[Technocrat]

I have three questions, I am almost positive that number one is a long shot and I doubt I am going to get many answers. But here it goes:

1) Does anyone have any source, examples, sites, docs, etc on attaching to and using data stored on an IBM AS/400? I am looking for any resources I can.

2) Does anyone have any source, examples, sites, docs, etc. on working with a database using ODBC?

3) Does anyone have any source, examples, sites, docs, etc on working with a database using SQL?

I need as much info as I can get my hands on so ANY help would be great. Thanks.

[jim mcnamara]

Answer to your first question:

IBM Client Access Express Data Transfer segment -- cwdx.dll

You need to have that on the PC, it's COM. IBM has documentation - I tired the URL I have, but it doesn't work.

[Technocrat]

Actually what I am looking for is how to access databases stored on an AS400.

I have found that with VB I can hook in to them using SQL commands and/or ODBC. So I think I am on the right track. Though I dont want any over head because I am going to be doing mainly just calcs with the data.

I have also found that I can get to it using stuff provided with Client Express, but for the life of me I can't figure it out. The examples that are provided by IBM are some of the worst documented ones I have ever seen. They are almost as bad as Novell's.