SQLCONNECT()

Purpose

Connect to an ODBC data source

Syntax

SQLCONNECT(<nStatementHandle>)

SQLCONNECT(<cDataSourceName> [, <cUserID> [, <cPassword>]])

See Also

SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLDISCONNECT(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLSTRINGCONNECT(), SQLTABLES(), SQLTRANSACTION()

Description

The SQLCONNECT() function is used to connect to an ODBC data source and return a statement handle for use by other SQL functions.

Keywords	Description
nStatementHandle	The workarea in which an ODBC data source is open and to which a new connection should be made.

Or

Keywords	Description
cDataSourceName	ODBC data source name
cUserID	Data source login user id
cPassword	Data source login password

Return values:

Return Value	Description
>0	Statement handle to connection
–2	Connection creation error

Example

nStatHand = SQLCONNECT("awhr", "testuser", "password", .T.)