Looks like the tnsnames.ora file was fine, but the ODBC driver itself had become corrupted. After ground-up re-install everything is working as expected now.
Looks like I panicked and called in the Calvary too soon! :)
Thanks!
Paul
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, April 26, 2018 9:50 AM To: profoxtech@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources?
Do you have the correct details for the tnsnames.ora that is in place at the client? Just having user/pw is not enough.
On Wed, Apr 25, 2018 at 4: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
Interestingly I'm using EMS's Oracle Manager software and it connects fine and returns queried data perfectly well. But no joy trying to connect directly with ODBC.
I'm going to try uninstalling my Oracle ODBC drivers and install the
latest
version of the drivers to see if that changes anything and if that fails I need to investigate using OLEDB. However, I have not been working OLEDB
and
am not sure how to proceed with that option.
So here's my question: Does anyone have any advice about connecting with ODBC to Oracle or do you have any resources you can point me to regarding using OLEDB to connect to Oracle.
Thanks in advance!
Paul
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]