>We have an oracle table out there somwhere that has some data in it I need. I read somewhere that VFP 6.0 can go out and get that data. The IT folks gave me an IP address, login and password and said good luck! I have no idea how to do this. Any suggestions as to how I do this?
>
>Thanks in advance BIG TIME for this one! :-)

Hi Randall,

Do you have an ODBC driver for Oracle installed? Once you have that, configure a DSN using the driver and the IP/UID/PWD you were given.

From withing VFP you:
1. Create a database (DBC)
2. Create a connection against the ODBC DSN
3. Create a remote view with the connection, grabbing data from the Oracle table you want.

Alternatively, you can use SQL PassThrough (SPT) and the ODBC driver and connection and avoid the view altogether.

The MSDN library on the MS website will have examples of all of this.