Connection Designer

JavaScript Editor js editor     Web development 



Main Page

Makes it possible for you to create and modify named connections. For more information, see How to: Define Connections to Remote Data Sources.

The Connection Designer is available only when a database is open because connections are stored as part of a database.

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 Stringtextbox 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



JavaScript Editor js editor     Web development