How To Connect to SQL Server Using a Trusted Connection in VFP

Last reviewed: November 18, 1996
Article ID: Q159590
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0

SUMMARY

SQL Server can be installed utilizing either Standard, Windows NT Integrated or Mixed security. The Trusted Connection is available only under Windows NT.

When creating a new DataSource via the ODBC dialog box in the Windows NT Control Panel, there is a check box in the lower left corner with the label, "Use Trusted Connection." Checking this option requests a trusted connection to SQL Server regardless of the security mode of the server. For information about the SQL Server login security mode and trusted connections, see the Microsoft SQL Server Administrator's Companion.

Once a DataSource has been created using a Trusted Connection, a connection can be created without supplying a user name and password. The user's Windows NT userid must exist on SQL Server.

To connect from Visual FoxPro via an available DataSource on a Windows NT machine:

  1. Create a DataSource on the Windows NT machine with the Trusted Connection box checked.

  2. In a program or Command window type: x=sqlconnect("datasource name here").

  3. Print the value of x, such as "? x". If x returns a positive number, then a valid connection was established.

To connect from Visual FoxPro via an available connection from a Window NT machine:

  1. Open up a project in Visual FoxPro.

  2. Select Connections.

  3. Select New.

  4. Choose a valid DataSource with the Trusted connection option checked.

  5. Leave the userid and password text boxes empty. a. Visual FoxPro 5.0 allows you to verify the connection via a command

          button.
    

  6. Select Remote Views from the project.

  7. Select New.

  8. Use the Connection created by the steps above.


KBCategory: kbinterop kbhowto
KBSubcategory: FxinteropOdbc
Additional reference words: 3.00 3.00b 5.00 kbdse vfoxwin



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 18, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.