OLEDB Connection Strings

image\OLEDBConnectionStrings.gif

 

Connection String Key Values

 

Key

Description/Notes

Valid Values

Provider

Name of the OLEDB provider to use for the connection.

 

String value.

Data Source

 

Name of server containing the data or path to file containing the data.

May not be used by some providers.

String value.xxx

UDL File

 

Universal Data Link file.

File that stores connection information.

Full path to UDL file.

Persist Security Info

Determines whether applications that use the connection can see sensitive information (e.g. password) stored in the connection string.

 

Checked = true

Unchecked = false