Setting Up the ConnectionString Property

When setting up a connection, you must specify certain information about the connection in the ConnectionString property. Typically, this would be user authentication information, the database name, and its location. The ConnectionString for the OLE DB provider also requires a provider parameter. Likewise, if you are using an ODBC connection, you must specify an ODBC driver name. Other settings are specific to the Data Provider being used.

Specifying a SqlConnection.ConnectionString

Table 18.3 lists the various parameters for the connection string. These parameters, although specific to SQL Server, are similar to the parameters for other data providers. The table shows the parameter name and alternates ...

Get Delphi for .NET Developer’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.