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

ID: Q157722

2.60a MACINTOSH 

 kbprb
The information in this article applies to:

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.

One of the two problems mentioned above occurs.

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

KBCategory: kbprb KBSubcategory: FxenvGeneral Additional reference words: 2.60a kbdsd FoxMac 

Keywords          : kbenv FxenvGeneral 
Version           : 2.60a
Platform          : MACINTOSH

Last Reviewed: May 13, 1998