>>>>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.
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)