AS400 to Access

[Brad Allison]

Okay, I need a bit of advice. I have an ODBC data adapter being filled by
AS400 which is very slow. If I were they user I would think that the
computer locked and try to stop the program, reboot, whatever.

So because management is still "investingating" ways of getting a faster
connection from our primary AS400 (which will never go away) to the internet
and internal employees I think some of the data will be able to be handled
with Access. I know, not the best way but something for now. I am not
familiar with DTS but what my thoughts are is to run a procedure once a week
during off hours that will fill the dataset (ds1) from the AS400's ODBC data
adapter then update the Access OLEDB data adapter using the same dataset.
Does anyone have any thoughts on this process?

I am trying my best to get the approval to the purchase of SQL, but nothing
yet and I have some projects lining up that would greatly benefit if
something like this is possible.

Thanks for any insight, comments, thoughts, ideas.

Brad

PS Besides SQL, the other ways being considered is: ASNA and another data
connection (can't remember it right now).

 

[Cor Ligthert]

Hi Brad,

Mostly I see in the dotNet groups questions answered about the AS400 by Jay
B. Harlow, he is as well active in this newsgroup however even more in
others from which I know

microsoft.public.dotnet.languages.vb,

When your question is that language related you can when you are in a hurry
ask it there (Jay B knows as well C# that is not the point. However you
cannot set a C# related question in the VB.Net newsgroup.)

I have collected messages by Jay B from the short past about AS400 on
dotnet, maybe you can use it as long as you have no answers from him or from
someone else.

He is not the only one who answers this AS400 questions however I saw him do
it the most.

You can look at this messages.

http://tinyurl.com/4avb8

I hope this helps?

Cor