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.
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?
By dhaya in forum Database
Last Post: 08-25-2003, 05:24 PM
By Azu in forum VB Classic
Last Post: 04-07-2003, 10:03 AM
By Thomas Eyde in forum .NET
Last Post: 12-22-2001, 02:13 PM
By Ted Young in forum VB Classic
Last Post: 08-09-2001, 07:37 AM
By Jean-Yves in forum Enterprise
Last Post: 06-01-2000, 12:23 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL