>>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
>
>You cannot run a single SQL Query against two databases that reside on seperate remote machines via ODBC. You will either have to access them as native tables or if you must use ODBC then you will have to perform seperate SQL queries against each table and return whatever subset of data is possible into cursors. Then run your sql against the two cursors.
Thanks fo your reply
I was affraid for that
I that case i have to combine the directories but that gives
a lot of problems
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only