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 ---
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]
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]
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 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 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 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]
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]
-
Fletcher Johnson -
Stephen Russell -
Ted Roche