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 --- _______________________________________________ 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.
