Microsoft KB Archive/305317

= PRB: SQL Builder Improperly Refreshes upon Editing Query When Data Is Located on Mapped Drive =

Article ID: 305317

Article Last Modified on 8/16/2001

-

APPLIES TO


 * Microsoft Visual Basic 6.0 Enterprise Edition

-



This article was previously published under Q305317



SYMPTOMS
When data is located on a mapped drive, SQL Builder improperly refreshes upon editing a query.



Steps to Reproduce Behavior

 * 1) On the server computer, create a share that allows access to a Microsoft Visual FoxPro .dbf file.
 * 2) On the local computer, map a drive to the share as drive N.

NOTE: This is not performed on the same computer as in step 1.
 * 1) On the local computer, create a data source name (DSN) that points to the .dbf file in step one.
 * 2) Open a new data project in Visual Basic.
 * 3) Double-click DataEnvironment1 to open the Data Environment designer.
 * 4) Right-click Connection1, and then click Properties.
 * 5) Click Microsoft OLE DB Provider for ODBC Driver, and then click Next to move to the Connection tab.
 * 6) In the Data source name drop-down list box, click the DSN that you created in step 3. Test the connection, and close the dialog box.
 * 7) Right-click Connection1, and then click Add a command.
 * 8) Right-click Command1, and then click Properties.
 * 9) Select the SQL Statement option, and then click SQL Builder.
 * 10) From the DataView window, click to expand the folders, and drag the table to the top pane of the SQL Builder.
 * 11) Select a few fields from the list in the top pane, run the query to verify that it works, and then save the query.
 * 12) Reopen SQL Builder, and select another field from the top pane. Notice that the SQL statement has changed.

Keywords: kbprb KB305317

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.