Ted,
Great to chat with you again.
While we have only been focusing on the ODBC 32 console, it didn't occur to me that the default install may not have installed the 32 bit drivers since we can see the Oracle option on the ODBC 32 manager. But this could be the old generic Oracle. Let me check into this possibility.
Thanks!
Fletcher
Fletcher Johnson FletcherSJohnson@Yahoo.com LinkedIn.com/in/FletcherJohnson beknown.com/FletcherJohnson twitter.com/fletcherJ strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, August 4, 2016 12:04 PM To: profox@leafe.com Subject: Re: ODBC connections to Oracle problem
Fletcher:
Long time indeed! Hope life is treating you well.
The first thing to check is the "bit-ness" -- VFP is 32-bit only. If they are on a 64-bit WIndows plarform, and if they are talking to Oracle via ODBC, then they need to install the 32-bit ODBC drivers, and use the 32-bit ODBC Administrator (not the one that's easy to find in the Control Panel) to connect VFP to Oracle.
https://support.microsoft.com/en-us/kb/942976
On Thu, Aug 4, 2016 at 2:37 PM, Fletcher Johnson FletcherSJohnson@yahoo.com wrote:
Hi all,
Long time, no chat.. But I still lurk. It's good to see this much chatter on such a great product.
Anyway, I have a former (and now current) client who has 2 applications written in VFP 8 or 9 that talk to an Oracle server. The programs were written back in 2000, with the last build being around 2006 or so. At that time, it was working with Oracle 8i.
They have set up some new computers and installed Oracle 11. They have no access to Oracle 8i (Oracle long since discontinued it.) Even if a 3rd party still has it available, due to various reasons, they could not use a version from any source other than the original
manufacturer.
The problem is that their initial attempts to get it working did not work. They have some people working on it, but I thought I would check with you to see if any of you have any ideas why it might not work (and better, what to do to fix it.) The problem seems to be around the TNS approach they used to route to the correct server.
I did find some source code, but not sure if it is the same as what is in the .exe they run. So my preference is to get it to run without having to create a new exe.
Anyway, I appreciate any suggestions you may have.
Fletcher
Fletcher Johnson
mailto:FletcherSJohnson@Yahoo.com FletcherSJohnson@Yahoo.com
http://linkedin.com/in/FletcherJohnson LinkedIn.com/in/FletcherJohnson
http://beknown.com/FletcherJohnson beknown.com/FletcherJohnson
twitter.com/fletcherJ
https://www.strava.com/athletes/fletcherjohnson strava.com/athletes/fletcherjohnson
408-946-0960 - work
408-781-2345 - cell
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]