>>>I have foxpro 2.6 databases on more locations.
>>>
>>>I can not changes the locations
>>>
>>>I what to make an ODBC connection to tables on both location.
>>>
>>>Now i have 2 connection.
>>>
>>>I have to make a query over 2 databases from both locations
>>>
>>>lsql = 'select * from tableloc1,tableloc2 where tableloc1.zipcode=tableloc2.zipcode'
>>>
>>>
>>>=sqlexec(connection1,lsql,"temp") &&Not connection2
>>>I can only use connection this does not wotk
>>>
>>>Can someone help me
>>>
>>>Kinde regards
>>>
>>>Jan Dorresteijn
>>
>>Jan,
>>
>>why do you need an ODBC-Connection ?
>
>The databases are from different systeems
>
>The new program has to be prepared to work with sql server


Jan,

I understand now. I'm sorry but I can't add anything new to waht Michael has already posted. He is right, it seems to be the only way.