(This value is not configurable in the connect string.The name of the application, or '.NET SQLClient Data Provider' if no application name is provided. In the case above, with a bad server name, an error is returned in 5 seconds. The actual error returned by the timeout setting in this string is generated only if the server can establish the connection, but, it is very busy or the network is very slow to respond. However, several errors are not affected by the timeout setting in this string, such as: You might expect your ADO.NET application to wait indefinitely before it returns. In this example, "Server=faircom2" is a bad server name:Ĭonn.ConnectionString = "ConnectionTimeout=0 UID=ADMIN PWD=ADMIN Database=ctreeSQL Datasource= Service=6597"
The following connection string sets the timeout to never expire. "UID=ADMIN PWD=ADMIN Database=ctreeSQL Server=localhost Service=6597 ssl=peerAuthentication sslcert=" "UID=ADMIN PWD=ADMIN Database=ctreeSQL Server=localhost Service=6597 ssl=basic" "User ID=ADMIN Password=ADMIN database=ctreeSQL server=localhost port=6597” Required when peerAuthentication is requested to provide certificate defined server nameĪ typical connection string for the FairCom DB ADO.NET Data Provider would be composed of: (optional) Values of basic (no peer certificate authentication) or peerAuthentication (server certificate authentication) The transaction isolation level for the connection.
If a value is not specified, then all connection objects will stay in the connection pool regardless of use and never be disposed.
Number of seconds a connection sits idle in the pool before being disposed. The connection will disconnect after this value has elapsed with no response. Number of seconds a particular connection object waits for an answer from the FairCom DB SQL server. The TCP/IP port number used by FairCom DB SQL. The TCP/IP address of the FairCom DB SQL installation. If other values are not specified, default values will be assigned as noted. The minimum required are User ID and Password. The most common synonyms are shown below. You can use any of the synonyms as a replacement for the Name portion of the pair to remain cross-compatible with usage of other database products. The following table lists Name-Value pairs used in connection strings for the FairCom DB SQL ADO.NET Data Provider. The Name portion of the Name-Value pair is not case-sensitive. FairCom ADO.NET Driver - Developer's GuideĪDO.NET connection strings are passed into CtreeSqlConnection objects as semicolon-separated Name-Value pairs.
0 kommentar(er)
