>>>>I'm currently working on migrating data from VFP to Oracle 8 with the help of Data Junction (ETL tool)
>>>>
>>>>Is there any way to access a Visual FoxPro Remote View within a DBC via ODBC or OLEDB?
>>>>
>>>>I've try creating a local view on the remote view without any success.
>>>
>>>Luc,
>>>VFP already does it using ODBC. You can use the same definitions and use ODBC or create an OLEDB one (you don't need to go through VFP dbc).
>>>Cetin
>>
>>Hi Cetin,
>>
>>I'm able to acess local view but not remote view. I can also create a local view on the remote view (FoxPro let's me do it) But when accessing the local view via OLEDB or ODBC It doesn't work.
>
>Luc,
>Probably you got me wrong. If VFP can access it using ODBC what's the reason you can't using ODBC? I mean why are you trying to access it through VFP, access directly.
>Cetin



I'm probably not clear,


Let look at the schema below:
DJ stands for Data Junction


DJ-->(ODBC)-->FOXDBC(LOCAL V1) Works!

DJ-->(ODBC)-->FOXDBC(LOCAL V2)<--(local table T1)+ (Local view V1) Works!

DJ-->(ODBC)-->FOXDBC(REMOTE V3)<--(base on ACCESSS table T2) Failed!

DJ-->(ODBC)-->FOXDBC(LOCAL V4)<--(based on Remote V3) Failed!


In all case, Within the DBC all views works but when accessing via a third party software via ODBC, there is some kind of problem with Remote view.