>hi friends,
>
>how can i use ORACLE database in my VFP applications (step by step what should i do )
>
>Thanks
Hi,
You can use ODBC to access Oracle database in VFP.
1. Check if the workstation has Oracle ODBC driver installed. It can be downloaded at
www.microsoft.com/data/download.htm.
2. In Control panel -> DataSources ODBC, create a System DSN with the ODBC driver.
3. Create a connection in VFP database. I suggest use "connection string".
Select the DSN created in step 2 and key-in the user and password.
4. Then, you can create a Remote view in the database so that you can access the Oracle tables.
A "Remote view" is just like a normal VFP table, you can "USE" it. Also, you can update the remote view if updatible fields is defined.
Wilfred