Neoview ADO.NET Provider Manual (R2.5)

Table 3-1 Connection String Properties (continued)
DescriptionDefaultName
Number of seconds of idle time, after which the client is disconnected600
IdleTimeout
Kilobytes of memory to allocate for the server-side data buffer4096
FetchBufferSize
The application name
Example: MyApplication
N.A.
ApplicationName
Delimiting Special Characters in a Connection String
Special characters in the connection string, such as spaces or semicolons, must be used with
delimiter, or quoting, characters. If you also use delimiter characters as special characters in the
connection string, they must also be quoted.
NOTE: Single or double quote characters within a value do not require delimiters. For example,
Data Source=my'Server or Data Source=my"Server.
These are the conventions for delimiter characters in the Neoview ADO.NET connection string:
Table 3-2 Delimiting Special Characters in a Connection String
Delimiter (Quoting) character(s)Special character in the connection string
Single (') or double (“) quotation marksSpaces (leading or trailing)
Double quotation marks (“)
NOTE: You can use the double-quote (“) if the value
begins with a single quotation mark (').
You can use a single quotation mark (') if the value
contains both a semicolon and a double-quote character,
or if the value begins with a double-quote(“).
If the value contains both single-quote (') and
double-quote (“) special characters, the quoting character
used to enclose the value must be doubled (repeated)
every time the special character occurs within the value.
Semicolon (;)
Leading or trailing single quote(')
Leading or trailing double-quote(“)
N.A.
These spaces are ignored, even if they are delimited.
NOTE: Spaces within a string literal keyword or value
are preserved.
Leading or trailing spaces around integer, Boolean, or
enumerated values
Neoview Schema Collections for ADO.NET
The Microsoft common schema collections are required for ADO.NET providers.
The values passed into the NeoviewConnection.getSchema() function are discussed in the
following tables. The Column Name lists columns returned from the call. The Restriction Name
lists restrictions allowed for the call.
The values to pass are not case sensitive, but must be the plural form with no spaces. For example,
primarykeys, but not primary keys.
• “Catalogs” (page 17)
• “Schemas” (page 17)
• “Tables” (page 17)
• “Views” (page 18)
• “Indexes” (page 18)
16 ADO.NET for Neoview