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