>Remote is successful for each, but I WANT both -->
> Create SQL View AVPRODUCTION Remote Connection AVPROD1, AVTDM1 As;
>
>What is the correct way to access more than one established connection in VFP?
The way to accomplish what you are asking is to query each connection and put the results in a VFP cursor and then use a SELECT on those cursors to join the data together, as in;
lh1 = SQLStringConnect("connect to oracle 8")
lh2 = SQLStringConnect("connect to SQL Server")
SQLExec(lh1,"Some Query","Cursor1")
SQLExec(lh2,"Some Query","Cursor2")
SELECT * FROM Cursor1 JOIN Cursor2 ON Cursor1.PK = Cursor2.FK WHERE ... ORDER BY ... INTO CURSOR MyResults