• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

Oracle8/Foxpro/Windows7

HI:
Just a quick question - have just acquired windows7 pc. Attempting to run foxpro application that queries oracle8 data; just hangs.
I can query oracle8 using SQL PLus
Foxpro can read dbf tables in database.
Attempt to query oracle8  from foxpro just hangs.
I know MS does not support oracle 8 but the software is from an external software provider so stuck!
Maybe should roll back to XP?
Or has anybody found a workaround?
0
ClaytonGlass
Asked:
ClaytonGlass
  • 2
  • 2
1 Solution
 
pcelbaCommented:
What FoxPro command hangs? What Oracle driver do you use? What is the exact version of OS? What says the external software provider? Isn't it his responsibility to solve this problem? Is the OS you are using among supported OS for the application?

0
 
ClaytonGlassAuthor Commented:
Thanks!
OK:
I did not know what the prob was so installed vfp9 (plus sp2) on windows7 pc.
Going into database and verifying connection to server results in system hanging
Oracle ODBC DRIVER 8.01.05.00
Windows7 pro 32 bit
External provider says nothing! They do not support access to their database by any means other than their interface! I use vfp (and I recall you personally have helped considerably) to access and manipulate data.
vfp9 is supported by MS; I do not believe Oracle8 is.
I think I am stuck..but thanks anyway!


0
 
pcelbaCommented:
Yes, Microsoft does not support Oracle but FoxPro is also not supported at the level we would suppose... All ODBC drivers should communicate via standard protocols and some compatibility (less than 100% obviously) exists.

Try newer Oracle driver. It should support older database versions.

Also try to access the Oracle via SQL Pass-through from Command Window:

lnHandle = SQLCONNECT()  && select the driver from a dialog and provide login info
? lnHandle  && negative value menas error
? SQLEXEC(lnHandle, "<some SQL command here>", "cResult")
etc.

If an error occurs then you have to call AERROR() function for more details.

Also VFP installed on W7 could have access rights problems. Your data and code must be in a folder where you have sufficient rights (means not in VFP 9 home folder).

0
 
ClaytonGlassAuthor Commented:
Thanks again, pcelba!
Will follow your suggestions.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now