|
<< Click to Display Table of Contents >> Connection file structure |
  
|
|
<< Click to Display Table of Contents >> Connection file structure |
|
The contents of the config.ado file could look like this:
[Connections]
PUBS=Default
NORTHWIND=
[Pubs]
ConnectionString="Provider=sqloledb;Data Source=(LOCAL);Initial Catalog=pubs;User Id=sa;Password=;"
CursorLocation=AdUseClient
[Northwind]
ConnectionString="Provider=sqloledb;Data Source=(LOCAL);Initial Catalog=Northwind;User Id=sa;Password=;"
CursorLocation=AdUseClient
The section [Connections] contains the connection names that are used by tables in the directory where the file is located, and for each connection there is a section that contains at least the following values:
| ConnectionString: | The connection string |
| Cursorlocation: | The cursor location for the connection (one of the Cursor Location Enum values) |