Can Oracle query Foxpro?

[todder]

Can Oracle query data in a Foxpro table?

I have heard that MS-SQL Server and Access can do this.

 

[VSU]

Yes. Using Oracle Heterogeneous Services

What is Heterogeneous Services?
===============================
Heterogeneous Services (HS) is an integrated component within the Oracle8i database server, and provides the generic technology for accessing non-Oracle systems from the Oracle database server.

Oracle8i. Distributed Database Systems.
Release 2 (8.1.6). December 1999. A76960-01
Part III.Heterogeneous Services Concepts and Administration)

 

[todder]

right on!

you da man.

little did I know that I should be searching on the word like heterogenous...

 

[DoubleH]

Ya,
Create a db link for foxpro. And then use that link name for accessing the foxpro tables like ..
select * from emp@foxpro_dblink;
Thanks,
DoubleH

 

[ryeolivier]

or you can create an odbc referencing to your foxpro file... then on your forms and/or database you can easily manipulate your foxpro db.

regards

 

[VSU]

http://otn.oracle.com/doc/oracle8i_816/server.816/a76960/part3.htm#435958

Oracle8i. Distributed Database Systems.
Release 2 (8.1.6). December 1999. A76960-01
Part III.Heterogeneous Services Concepts and Administration)