Solved

Accessing a visual foxpro database from a java web app

Posted on 2007-03-23
4
244 Views
Last Modified: 2010-03-31
I am wondering if anyone has had luck accessing a VFP database via the web using Java?  We are currently working on a prototype and are using the free JDBC-ODBC driver which seems to work fine except on some of my more complex queries.  For some reason it will not execute imbedded select statements.  These run fine in the actual foxpro development system, so is it just that I need a better driver/bridge?
0
Comment
Question by:JLLange
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 125 total points
ID: 18781368
>>so is it just that I need a better driver/bridge?

Yes probably
0
 
LVL 20

Assisted Solution

by:gatorvip
gatorvip earned 125 total points
ID: 18781503
Check the documentation for the driver that you use now, if it doesn't allow "complicated" queries it should probably be documented
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
Suggested Courses

626 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