Is it possible to connect to Oracle data using an oledb driver from Visual FoxPro? I don't want to have to load an oracle ODBC connection on every machine that needs a connection to Oracle. This is a new area for us and we are trying minimize support. If this is possible, what is needed on both sides?
The only answer here is that you'll just have to test your app to verify that all the features work properly via the Visual Foxpro oledb driver. There is nothing specific on Metalink regarding that driver in particular, but there are several issues with the Microsoft OLE DB Provider for Oracle which have presented problems in some cases.
The bottom line is that Oracle's driver is going to be the most robust, but if you can verify all your application functionality works with another driver, there's no reason not to use it.