PRB: File 'FPSQL' Does Not Exist Error in FoxPro for Macintosh

• Microsoft FoxPro for Macintosh, version 2.6a

SYMPTOMS

When trying to run an executable with a SET LIBRARY TO Fpsql.mlb command, the executable quits on that command or returns the following error message:

   File 'FPSQL' does not exist.

RESOLUTION

Place the file Reserved.mlb in the extensions folder.

STATUS

Microsoft is researching this behavior and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

This problem has been detected under system 7.5.3. It may or may not exist under other operating systems.

Steps to Reproduce Behavior

1. Open a new project on a Power Mac and create a program with the following code:

         WAIT WINDOW "FPSQL not set yet"
         SET LIBRARY TO FPSQL.MLB
         WAIT WINDOW "FPSQL is now set"
   

2. Create a 68K executable, and run the Setup Wizard to create disks.

3. On a separate disk, create two folders: one called Control Panels and the other called Extensions.

4. Copy the ODBC Setup file in the Control Panels folder of the PowerMac to the Control Panels folder on the disk.

5. Copy the following files from the Extensions folder of the PowerMac to the Extensions folder on the disk.

          ODBC Driver Manager
          ODBC Configuration Manager
          Fpsql.mlb
          Reserved.mlb
   

6. Install the disks on a clean system on a Quadra or a Performa. Restart the Macintosh as directed.

7. Copy the ODBC Setup file to the Control Panels folder of the Quadra or Performa.

8. Copy the all the files except Reserved.mlb listed in step 5 to the Extensions folder of the Quadra or Performa.

9. Restart the Quadra or Performa, and run the executable.

Now place the Reserved.mlb in the Extensions folder and restart. The executable now runs without error.