Stephan, Good to hear from you, it's been a while. Nice to hear from a friendly face.
The TNSNames.ora file was around back in the 8i days, so we are used to it. But we can't figure out why we are not connecting yet. But we keep looking... 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 Stephen Russell Sent: Thursday, August 4, 2016 12:40 PM To: ProFox Email List Subject: Re: ODBC connections to Oracle problem Then you have to have access to the: http://www.orafaq.com/wiki/Tnsnames.ora For Oracle to let you in and play. On Thu, Aug 4, 2016 at 2:03 PM, Ted Roche <[email protected]> wrote: > 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.
