Connection file structure

<< Click to Display Table of Contents >>

Navigation:  The Vo2Ado RDD > Appendices > File structures >

Connection file structure

Previous pageReturn to chapter overviewNext page

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)