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