Q
Problem solve Get help with specific problems with your technologies, process and projects.

Connecting Oracle and Visual FoxPro

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.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close