Hello Jim,

You're Right... That's what I'm working on now - thanks

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