Difference between revisions of "SQLSTRINGCONNECT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 4: Line 4:
  
 
==Syntax==
 
==Syntax==
SQLSTRINGCONNECT([<lShared>] | [<cConnectString> [, <lShared>]])
+
SQLSTRINGCONNECT([<lShared>,] [<cConnectString> [, <lShared>]])
  
  
 
==See Also==
 
==See Also==
[[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLEXEC()]], [[SQLGETPROP()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLTABLES()]]
+
[[CREATE CONNECTION]], [[SQLCANCEL()]], [[SQLCOLUMNS()]], [[SQLCOMMIT()]], [[SQLCONNECT()]], [[SQLDISCONNECT()]], [[SQLERROR()]], [[SQLEXEC()]], [[SQLGETPROP()]], [[SQLMORERESULTS()]], [[SQLPREPARE()]], [[SQLROLLBACK()]], [[SQLSETPROP()]], [[SQLTABLES()]]
  
 
==Description==
 
==Description==
Line 46: Line 46:
 
|Driver:DataSource ||ODBC, OLEDB or JDBC server side data source in the format:
 
|Driver:DataSource ||ODBC, OLEDB or JDBC server side data source in the format:
 
odbc:odbc_data_source_name_on_server
 
odbc:odbc_data_source_name_on_server
 +
 
oledb:oledb_connection_string_on_server
 
oledb:oledb_connection_string_on_server
 +
 
jdbc:dbc_driver_path_on_server;jdbc:Recital:args
 
jdbc:dbc_driver_path_on_server;jdbc:Recital:args
 
|-
 
|-
 
|}
 
|}
 
  
 
====Return values:====
 
====Return values:====

Latest revision as of 16:15, 4 July 2011

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(), SQLERROR(), 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.


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, Recital Server