SQLSTRINGCONNECT( ) Function

Example   See Also

Establishes a connection to a data source through a connection string.

Syntax

SQLSTRINGCONNECT([cConnectString])

Returns

Numeric

Arguments

cConnectString

Specifies the data source connection string required by some ODBC drivers. Visual FoxPro passes the connection string to the ODBC driver. For more information about data source connection strings, see your ODBC driver documentation.

If SQLSTRINGCONNECT( ) is issued without cConnectString, the SQL Data Sources dialog box is displayed, allowing you to choose a data source.

Remarks

SQLSTRINGCONNECT( ) returns a positive non-zero numeric handle if you successfully connect to the data source. You should store this handle in a memory variable and use the variable in subsequent function calls that require a connection handle.