Connecting to AS/400 from VB

[Christine]

Has anyone tried using the IBM OLEDB Provider?
I am able to connect to AS/400 and I can insert records into the file but thats it. I cannot select records.
I am using the following syntax to select from a file
Set adorecordset = adoconn.execute "Select * from LibName.FileName".
When this execute the app blows up.
I have Client Access installed on my PC V3r1m3.

Does anyone know where I could find a driver?
I am also having no luck using odbc - IBM's Client Access Driver.
Any Suggestions?
Thanks
Christine

[ledger]

I have not tried the method you mentioned.

The easiest way I found was to create an Access database as an intermediate step. ie. a local mdb file that contains linked tables to the AS/400 using the client access driver.
Then run the query on the linked tables.

I know this isn't brilliant but it works.