Hi Mark:
I obtained your article entitled "connecting VFP to Oracle" from the
Knowledgebase and am using it as a guide to make a connection
from VFP 5.0 to an Oracle Server 7.3.
I have never used Oracle before and hence may be the cause of some of my
problems. We have recently tested an SQl Server as a backend and
decided to test Oracle as well.
At this point I am trying to make a connection using the same workstation
as the client and server. In your article you state that the SQL* NET
version needs to be installed on the client. So if I'm using the same
workstation to make a connection at this point I already have it installed
????
I'm attempting to create my connection through obdc32 administrator.
I include all necesaary information yet when I verify connection it does
not work.
Also, should I edit the tnsnames.ora file, i.e. if the example you have
shown
should I be placing my database name where you have MyDbName in my file. I
was going to attempt this and there was a comment in that file that states
not to modify the file,,,, being a novice I didn't risk it.
Finally, in what directory on other client machines do I place the SQLNet?
In the windows systems directory?
Any answers or suggestions would be very appreciated.
Sincerely,
Sheena Escott -
email -
pescott@nfld.com