SQLSTRINGCONNECT()

From Recital Documentation Wiki
Revision as of 16:38, 13 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

SQLSTRINGCONNECT()

Class

SQL Applications


Purpose

Connect to a data source using a gateway connection string


Syntax

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


See Also

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

Description

The SQLSTRINGCONNECT() function is used to connect to a data source using a gateway connection string 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. The cConnectString gateway connection string format is: server@machinename:username/password-database.protocol. The shortened driver:datasource format can also be used for ODBC, OLEDB or JDBC data sources on the server.

If cConnectString is not specified, the ’Select a Gateway’ dialog is displayed allowing an existing gateway definition file (.gtw) to be selected. Gateway files can be created in Recital Terminal Developer using the CREATE GATEWAY | MODIFY GATEWAY tool or via the CREATE CONNECTION command.

Gateway connection string format for 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:Recital:args

Return values:

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


Example

// When cConnectString is omitted, ’Select a Gateway’ dialog is displayed
// Specify connection should be shared
nStatHand = SQLSTRINGCONNECT(.T.)
 
// Including cConnectString makes the connection
// 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.)


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer