Share via

Connection Designer

  • Article

Use the Connection Designer to create and modify named connections. Because connections are stored as part of a database, you only can use the Connection Designer if you have a database open.

For more information on creating connections, see "Defining a Connection" in Accessing Remote Data.

Specify Datasource

  • Data Source, Userid, Password
    Specifies that Visual FoxPro display the following three boxes:
    • Data Source   Makes it possible for you to choose a data source from the list of installed ODBC data sources.
    • Userid   Makes it possible for you to enter a user name or ID if the data source requires one.
    • Password   Makes it possible for you to enter a password if the data source requires one.
    • Database   Makes it possible for you to choose a database for the selected data source to connect to.
  • Connection String
    Specifies that Visual FoxPro display the Connect String textbox in which you type a connection string. Choosing the dialog button displays the Select Connection or Data Source Dialog Box, allowing you to select an existing file or machine data source.
  • Verify Connection
    Makes it possible for you to check the connection you have just entered information for. If the connection was made successfully, a dialog box appears to indicate this. If the connection was not successful, an error message appears. If no information has been specified for the connection, the Select Database dialog box appears, which makes it possible for you to select a data source.
  • New Data Source
    Displays the Data Sources dialog box, which makes it possible for you to add, delete, or configure data sources.

Display ODBC Login Prompts

  • When Login Info Is Not Specified
    Specifies that Visual FoxPro prompt the user with the ODBC Data Source Login dialog box if the user ID and password are not stored in the named connection definition.
  • Always
    Specifies that Visual FoxPro always prompt the user with the ODBC Data Source Login dialog box. This enables the user to use a different login ID and password from those stored in the named connection.
  • Never
    Specifies that Visual FoxPro never prompt the user. This option ensures higher security.

Data Processing

These options correspond to connection properties that you can also set with the DBSETPROP( ) Function. For more information about these properties, see the connection properties in the DBGETPROP( ) Function.

  • Asynchronous Execution
    Specifies an asynchronous connection. This option corresponds to the Asynchronous connection property.
  • Display Warnings
    Specifies the display of non-trappable warnings. This option corresponds to the DispWarnings connection property.
  • Batch Processing
    Specifies that the connection operate in batch mode. This option corresponds to the BatchMode connection property.
  • Automatic Transactions
    Specifies that the transaction processing is automatically handled. This option corresponds to the Transactions connection property.
  • Packet Size
    Makes it possible for you to specify the network packet size (in bytes) for information transmitted to and from the remote data site. Select a choice from the drop-down list, or type a value.

Timeout Intervals

These options set values for connection properties that you can also set with the DBSETPROP( ) function. For more information about these properties, see connection properties in the DBGETPROP( ) Function.

  • Connection (sec)
    Specifies the connection timeout interval in seconds. This option corresponds to the ConnectTimeout connection property.
  • Query (sec)
    Specifies the query timeout interval in seconds. This option corresponds to the QueryTimeout connection property.
  • Idle (min)
    Specifies the idle timeout interval in minutes. Active connections are deactivated after the specified time interval. This option corresponds to the IdleTimeout connection property.
  • Wait Time (ms)
    Specifies the amount of time in milliseconds that elapses before Visual FoxPro determines whether the SQL statement has completed executing. This option corresponds to the WaitTime connection property.

See Also

CREATE CONNECTION command | DBGETPROP( ) Function | DBSETPROP( ) Function | DELETE CONNECTION Command | DISPLAY CONNECTIONS Command | LIST CONNECTIONS Command | MODIFY CONNECTION Command | RENAME CONNECTION Command | SQLCONNECT( ) Function | SQLDISCONNECT( ) Function | SQLGETPROP( ) Function | SQLSETPROP( ) Function