|
- WLanguage properties that can be used with a connection described by programming
- Native Oracle access: managing the external authentication
- Equivalence between code: Describing a connection
- Equivalence between code: Establishing a connection
- Equivalence between codes: Assigning a connection
- Equivalence between codes: Modifying an existing connection
Connection (Type of variable) In french: Connexion
Not available with this kind of connection
The Connection type is used to describe one or more connections to external databases (HFSQL Client/Server, Native Access, ). Then, this connection can be opened by HOpenConnection. The characteristics of this connection can be defined and modified by several WLanguage properties. Versions 17 and later New in version 17The Connection variable can also be used to: Remark: See Declaring a variable for more details on the declaration of this type of variable and the use of WLanguage properties. Remark: From version 19, HFSQL is the new name of HyperFileSQL.
MyConnection is Connection
// Describe the connection MyConnection..User = "USER" MyConnection..Password = "PASSWORD" MyConnection..Server = "MYSERVER" MyConnection..Database = "Database" MyConnection..Provider = hAccessHFClientServer MyConnection..Access = hOReadWrite MyConnection..ExtendedInfo = "Extended information" MyConnection..CursorOptions = hClientCursor
// Open the connection HOpenConnection(MyConnection)
// Assign the connection to all data files HChangeConnection("*", MyConnection)
Remarks WLanguage properties that can be used with a connection described by programming The properties specific to the connections are presented in the table below: Remark: ..Provider and ..Server or ..Provider and ..Source must necessarily be initialized when describing a connection. | | Property name | Effect |
---|
Access | Allows you to manage the type of access for a connection (HFSQL Client/Server, OLE DB, ...): Read, Read/Write | ActiveDirectory | Used to manage the connection via Active Directory. | Database | Allows you to manage the name of the database associated with a connection (HFSQL Client/Server, OLE DB, ...).In the case of a database divided into schemas, the name of the schema in the database will be specified by HChangeName. | Compression | Allows you to manage the compression of data transmitted by the connection. | CryptMethod | Allows you to manage the type of encryption for the communication between the Client computers and the HFSQL server. | ExtendedInfo | Allows you to manage the additional information of a connection. | Caption | Allows you to find out and modify the caption of a connection. | Password | Allows you to modify the password associated with the user of a connection. | Name | Allows you to find out the name of the connection | CursorOptions | Allows you to manage the different types of cursors used by the connection. | Provider | Allows you to manage the type of data handled by the connection. | Server | Allows you to manage the name of the server used in the connection. This property is identical to ..Source. This property is mainly used for the HFSQL Client/Server connections or for the Native Accesses on the servers. | Source | Allows you to manage the name of the data source used in the connection. This property is identical to ..Server. This property is mainly used for a connection on MS Access or on an xBase file. . | CacheSize | Allows you to manage the size of the cache | User | Allows you to manage the user of the connection |
Versions 18 and later New in version 18Equivalence between code: Describing a connection
HDescribeConnection("MyConnection", "USER", "PASSWORD", "TESTSERVER", ... "Database", hAccessHFClientServer, hOReadWrite, ... "Extended info", hClientCursor)
Code that is using the connection:
MyConnection is Connection // Describe the connection MyConnection..User = "USER" MyConnection..Password = "PASSWORD" MyConnection..Server = "TESTSERVER" MyConnection..Database = "Database" MyConnection..Provider = hAccessHFClientServer MyConnection..Access = hOReadWrite MyConnection..ExtendedInfo = "Extended information" MyConnection..CursorOptions = hClientCursor
Equivalence between code: Establishing a connection
HOpenConnection("MyConnection", "USER", "PASSWORD", "TESTSERVER", ... "Database", hAccessHFClientServer, hOReadWrite, ... "Extended info", hClientCursor)
Code that is using the connection:
MyConnection is Connection // Describe the connection MyConnection..User = "USER" MyConnection..Password = "PASSWORD" MyConnection..Server = "TESTSERVER" MyConnection..Database = "Database" MyConnection..Provider = hAccessHFClientServer MyConnection..Access = hOReadWrite MyConnection..ExtendedInfo = "Extended information" MyConnection..CursorOptions = hClientCursor HOpenConnection(MyConnection)
Equivalence between codes: Assigning a connection
HChangeConnection(CLIENT, MyConnection)
Code that is using the connection:
CLIENT..Connection = MyConnection
Equivalence between codes: Modifying an existing connection
HDescribeConnection(MyConnection, "USER2", "PASSWORD2", MyConnection..CtDatabase, ... MyConnection..CtInitialCatalog, ... MyConnection..CtOLEDBProvider, MyConnection..CtAccess, ... MyConnection..CtExtendedInfo, MyConnection..CtCursorOptions)
Code that is using the connection:
// Modifies the login and password for the connection MyConnection..User = "USER2" MyConnection..Password = "PASSWORD2"
This page is also available for…
|
|
|
| |
| Click [Add] to post a comment |
|
| |
|
| |
| |
| |
| |
| |
| |
| | |
| |