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 [email protected] 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:[email protected]] On Behalf Of Ted Roche Sent: Thursday, August 4, 2016 12:04 PM To: [email protected] 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 <[email protected]> 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:[email protected]> [email protected] > > <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] _______________________________________________ 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.
