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 tedroche@gmail.com 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 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]