-
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
-
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.
