I remember vaguely that Oracle have a funny Oracle DB Integrator which needs to be installed in Oracle for ODBC to work, so maybe that is what they are on about. Perhaps what they meant is that they haven't purchased the rights to distribute the Integrator along with their products.
There are a few ODBC connectors around that you can freely download or purchase depending on their status but I have used the Microsoft one which I believe has been superseded by the newer V3 product: http://www.oracle.com/technetwork/products/rdb/index-089321.html All the "standard" (if there is such a thing) Oracle DB's I have come across have been accessible via the ODBC driver but I'm going back a couple of years since I used Oracle. Sorry I can't be more helpful, but I think it's a "try it and see" situation. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Dennis Schuette Sent: 07 March 2014 15:50 To: [email protected] Subject: RE: VFP, Oracle, and Famous Software That's what I thought too, but when I contacted Famous tech support, they said that they did not buy the ODBC option from Oracle. So, a few basic questions: 1. Is ODBC essentially a 3rd party product that can connect to any Oracle DB? 2. Is it possible to 'change the database format slightly to make it proprietary'? 3. Does Oracle have the ability to disable ODBC access? Unfortunately I do not have access to the customers database and Famous does not have a Demo version. Customized Business Services, LLC (928) 580-6352 Dennis Schuette Primary: [email protected] 350 West 16th Street, Suite 309 Alternate: [email protected] Yuma, AZ 85364 Map it -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Dave Crozier Sent: Friday, March 07, 2014 8:19 AM To: [email protected] Subject: RE: VFP, Oracle, and Famous Software If it is based on Oracle then surely you can use the standard ODBC Oracle connector, unless of course they have changed the database format slightly to make it proprietory. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Dennis Schuette Sent: 07 March 2014 15:00 To: [email protected] Subject: VFP, Oracle, and Famous Software I have a couple of customers that use http://www.famoussoftware.com/ which is based on Oracle. Famous 'famously' has rather inflexible reporting built in and did not purchase Oracle's ODBC option. Famous, however, DOES (surprise!) offer a reporting product called 'Face Forward' is offered that extracts data into PDF, Excel, etc. Face Forward is priced in modules, as are the data dictionaries (sold separately). I have no experience with Oracle. Is there a way to query data from Oracle tables from within VFP without having ODBC? Dennis Schuette --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
