I thought OLEDB was a proprietary Microsoft technology and they stopped pushing that a while ago?
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Paul H. Tarver Sent: Thursday, April 26, 2018 12:07 PM To: profoxtech@leafe.com Subject: RE: ODBC or OLEDB to Oracle - Resources?
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:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, April 26, 2018 6:13 AM To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver paul@tpcqpc.com 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.