Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing Fox DBC Views via ODBC or OLEDB
Message
From
21/04/2005 06:54:14
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01006184
Message ID:
01006885
Views:
22
>>>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform