SQLSTRINGCONNECT()

Purpose

Connect to a data source

Syntax

SQLSTRINGCONNECT([<lShared>,] [<cConnectString> [, <lShared>]])

See Also

SQLCANCEL(), SQLCOLUMNS(), SQLCOMMIT(), SQLCONNECT(), SQLDISCONNECT(), SQLERROR(), SQLEXEC(), SQLGETPROP(), SQLMORERESULTS(), SQLPREPARE(), SQLROLLBACK(), SQLSETPROP(), SQLTABLES()

Description

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

Keywords	Description
lShared	False (.F.) Connection created is not shared (default) True (.T.) Connection created is shared
cConnectString	The data source gateway connection string.

cConnectString:

Parameter	Description
Server	Database server name or abbreviation, e.g. mys or mysql.
Nodename	IP Address or hostname of the machine on which the database resides.
Username	Username to log in to the external database.
Password	Password for username above.
Database	Database to connect to.
Protocol	The network protocol. TCP/IP is assumed.
Driver:DataSource	ODBC, OLEDB or JDBC server side data source in the format: odbc:odbc_data_source_name_on_server oledb:oledb_connection_string_on_server jdbc:dbc_driver_path_on_server;jdbc:Lianja:args

Return values:

Return Value	Description
> 0	The workarea in which the gateway data source has been opened
–1	Connection creation error

Example

// Store the return value to use as the nStatementHandle for subsequent function calls
// Specify connection should be shared
nStatHand = SQLSTRINGCONNECT("mysql@linux1:user1/pass1-database1.tcpip",.T.)
 
// OLEDB DataSource
nStatHand = SQLSTRINGCONNECT ("oledb:Provider=vfpoledb.1;" +;
"Data Source=C:Data;Collating Sequence=general",.T.)