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]