Posted on 2011-05-09
Last Modified: 2012-05-11
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?
Question by:ClaytonGlass
    LVL 41

    Expert Comment

    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?


    Author Comment

    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
    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!

    LVL 41

    Accepted Solution

    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")

    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).


    Author Closing Comment

    Thanks again, pcelba!
    Will follow your suggestions.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: (http://msd…
    Read about the 3 stages of the buyer's journey: awareness, consideration, and decision.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now