I verified I was using the 32-bit version and since I had this working on this same computer for a previous client, I was pre-disposed to "ass-u-me" everything was working. However, after manually uninstalling the ODBC drivers and re-installing the drivers I downloaded yesterday, everything started working magically. I can only guess that the previous ODBC driver installation had become corrupted for some reason.
Back in the ODBC game for now. But still interested in the OLE options that might be available to me since I've not worked with that before. Paul -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Ted Roche Sent: Thursday, April 26, 2018 6:13 AM To: [email protected] Subject: Re: ODBC or OLEDB to Oracle - Resources? On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver <[email protected]> wrote: > I have been able to ODBC to an Oracle 11g database in the past for a > previous client but I've picked up a new client who is also on Oracle 11g > and I'm having a devil of a time to get the ODBC connection string working > either from within Foxpro or even from ODBC32.exe I have been tripped up, more than once, in not ensuring I am using all 32-bit components and the 32-bit ODBC Administrator when trying to connect from VFP. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [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.
