PRB: VFPODBC Driver Ignores Path in DSN When Executing SQL (192979)

   CREATE TABLE 'C:\PROGRAM FILES\MICROSOFT VISUAL STUDIO\MSDN98\98VS\1033\ 
   SAMPLES\VFP\DATA\MYTEST1' (FLD1 C(10),FLD2 N(6.2))
					

   CREATE TABLE d:\PROGRA~1\MICROS~1\MSDN98\98VS\1033\SAMPLES\vfp98\DATA\ 
   MYTEST1' (FLD1 C(10),FLD2 N(6.2))
					

MORE INFORMATION

The driver uses the current directory of the calling application for any work it must perform.

Steps to Reproduce Behavior

The following sample uses MSQUERY to show the behavior. Please note that MSQuery is not unique in this behavior. Any software that can issue a Create Table SQL command through an ODBC driver can be used to reproduce this behavior.

1. Create a Data Source using the Microsoft Visual FoxPro Driver that references the TestData.dbc. TestData.dbc is located in the Samples\Data (Samples\VFP\Data of the Visual FoxPro directory.
2. In MSQuery, click the Execute SQL option located on the File menu.
3. Copy and paste the following SQL string into the SQL Statement window:

         CREATE TABLE MYTEST1 (FLD1 C(10),FLD2 N(6,2))
   							

4. Click the Datasources button and select the datasource you created in Step 1.
5. Click the Execute button.
6. Click the Start menu, point to Find and then click Find Files. In the Find:All Files dialog box, type MyTest1.dbf in the Named text box. Click the Find button. Note that the MyTest1.dbf file is not in the Data directory with the TestData table.