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 <[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 > > > > 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] _______________________________________________ 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/CAJidMYLgmYxa2wXM==iz5shttnsdz_iqhibjgzcilcuva6d...@mail.gmail.com ** 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.
