Well if anybody else can answer this then give Chris a race for his money 
Based on my previous post it got me thinking about hoe EG retrieved the data.
It looked to me like EG retrieved the preview data into the EG project for the table selected, but failed to run the SAS query on the workspace server.
So from that I deduce that EG wasn’t using the workspace server to retrive the preview data.
Wonder if thats true or not?
Chris?
I’m not sure if it’s a good idea for me to respond to the “Bat Signal” hee. It might set a dangerous precedent.
I suspect that the issue was that you had somehow installed a previous version of the SAS Integration Technologies client (install any 9.1.3-era software lately?), and thus didn’t have access to some of the later 9.2 APIs that EG needs. One such API has to do with how EG retrieves the SAS log content, and so that wouldn’t create an issue until you tried to run a SAS program. EG uses a newer 9.2-only API to stream the log content back to the project more efficiently.
I hope that the error message was telling enough; I guess, since you got it resolved, it was at least adequate.
Thank you for the response but true, next time ill just use the bat signal and you can decide if your in town
We had EG 4.1 and EG 4.3 on the same machine so that makes sense.
The area I am still not sure of is does EG use the workspace server to query the data when you first drag a table into the project and it gives you the first 1000 odd rows, or does it use some other mechanism?
It depends.
If you have no SAS installed on your PC, then EG uses the SAS Local OLE DB Provider to read a local dataset file (sas7bdat). Then when you run a task or query, it connects to your remote SAS session and copies the data up, and then completes your job.
(Hint: you can make that faster by using Tasks->Data->Upload SAS Data Sets instead of opening the data directly on your PC.)
If you add data from a library, then yes, EG uses SAS to read the data from the get-go.
If you have SAS installed locally, then EG spins up SAS, assigns a temp library, and uses SAS to read the data.