![]() Breaking Changes and Migrating path Mappers Sets the Workstation name for process identification.Public Address Address Įach property is represented by a column in the database with the same name. Sets the value for the connection.Īlternate name: TRANSACTIONISOLATIONLEVEL NET Clients to Use SSL/TLS with Caché” in the Caché Security Administration Guide). Specifies whether SSL/TLS secures the client-server connection (see “ Configuring. Sets an upper limit to the number of SQL commands that will be held in the preparse cache before recycling is applied. Turns on logging and sets the log file location. Sets the length of time in seconds to try and establish a connection before failure. The following five parameters are required for all connection strings (see “ Creating a Connection”). The following tables describe all parameters that can be used in a connection string. The samples connect to the SAMPLES namespace, which is pre-installed with Caché. This should be the namespace containing the classes and data your program uses. Make sure that your connection URL includes a valid Caché namespace. If you want a sample program to default to a different username and password, you will need to change the sample code. Typically, you will change the default password after installing the server. The sample programs use the administrator username "_SYSTEM" and the default password "SYS". (You can manage usernames and passwords using the Management Portal: System Administration > Security > Users). Make sure that you have a valid username and password to use to establish a connection. If you want a sample program to default to a different port, you will need change the number in the sample code. Make sure that you know the TCP/IP port number on which the Caché Server is listening. If you want a sample program to default to a different system you will need to change the connection string in the code. Make sure that you know the IP address of the machine on which the Caché Server process is running. Make sure that the Caché Server process is installed and running. NET client that wishes to connect to a Caché Server needs the following information:Ī URL that provides the server IP address, port number, and Caché namespace.īy default, the sample programs use the following connection information:Ĭonnection string: "localhost:SAMPLES"Ĭheck the following points if you have any problems: This section describes the server settings required for a connection, and some troubleshooting tips.Įvery. The sample programs provided with Caché should work with no change following a default Caché installation. Very little configuration is required to use a. The default value is 0.įor example, the following connect string sets the initial size of the connection pool to 2 and the maximum number of connections to 5, and activates connection reset with a maximum connection idle time of 3 seconds:ĬachePoolManager.RemoveAllPoolConnections() ĭeletes all connections and removes all pools, regardless of what state the connections are in.įor a working example that uses most of these methods, see the Proxy_9_Connection_Pools() method in the bookdemos sample program (see “ The Caché. Connection Lifetime specifies the number of seconds to wait before resetting an idle pooled connection. Set these parameters to specify the maximum and minimum (initial) size of the connection pool for this specific connection string.Ĭonnection Reset and Connection Lifetime - Set Connection Reset to true to turn on the pooled connection reset mechanism. Min Pool Size and Max Pool Size - Default values are 0 and 100. Set Pooling to false to create a connection with no connection pooling. The following connection string parameters can be used to control various aspects of connection pooling: Connection PoolingĬonnection pooling is on by default. The ConnectDlg() method displays the standard Caché connection dialog and returns the user's input as a connection string. CacheConnect.ConnectionString = CacheConnection.ConnectDlg()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |