VB Foxpro Query failure


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: VB Foxpro Query failure

  1. #1
    Join Date
    Sep 2006
    Posts
    2

    VB Foxpro Query failure

    We have an application that connects to a Foxpro database. Another company sends us the databases and with their latest release, we're now having problems. Here are the relevant parts of the code.

    Public db As Database
    Public rs As Recordset
    ...
    Set db = DBEngine.Workspaces(0).OpenDatabase(Drive & "\" & databasePath & "\" , True, False, "FoxPro 3.0")
    ....
    Set rs = db.OpenRecordset(sSQL)

    We get the following error upon trying to open the recordset.
    The Microsoft Jet database engine could not find the object 'TABLENAME'. Make sure the object exists and that you spell its name and the path name correctly.

    We're using VB 6.0 with the latest Service Pack. Foxpro 6.0. DAO 3.51 is included as a reference in the VB project.

    I've verified that the table does exist at the path specified. The query is correct. I've opened Foxpro and run the query and the correct results are returned.

    Thanks for any help.

  2. #2
    Join Date
    Sep 2006
    Posts
    2
    On further investigation, the table names in the database have changed. They are now 11 characters long. When I change the table names back to what they were on the old versions, our code works.

    What needs to be updated to use longer file names?

Similar Threads

  1. query tuning
    By dhaya in forum Database
    Replies: 11
    Last Post: 08-25-2003, 06:24 PM
  2. Replies: 1
    Last Post: 04-07-2003, 11:03 AM
  3. They created J#, why couldn't they do VB#?
    By Thomas Eyde in forum .NET
    Replies: 290
    Last Post: 12-22-2001, 03:13 PM
  4. Replies: 1
    Last Post: 08-09-2001, 08:37 AM
  5. Re: VB or Powerbuilder?
    By Jean-Yves in forum Enterprise
    Replies: 3
    Last Post: 06-01-2000, 01:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center