You need the drivers for Oracle, then create an odbc connection. Once you've got that, you can pull data just like in MS SQL. I recommend you install the SQL Developer for Oracle too.
>Dear all,
>
>I wanted to create a view from the network on oracle database and use the resulting view in a foxpro program.
>
>How will I create the connection, do I need an oracle client installed in my computer before I could connect to the server where the oracle database/table is residing. Am I able to connect if I don't have access rights on the server from the network although I could be able to access the oracle database with admin rights locally. Will the view be updated automatically if the oracle table changes?
>
>By the way I have already added the ODBC for oracle in the odbc datasource, does the server here means the server name or shall include the oracle database name, i.e. Server=\\servername\oradatabase.
>
>Thanks for your assistance.
>
>Ed
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright