please dont rip this site

ConnectionString Property

Contains the information used to establish a connection to a data source.

Settings and Return Values

Sets or returns a String value.


Use the ConnectionString property to specify a data source by passing a data source name (DSN) or a detailed connection string containing a series of argument = value statements separated by semicolons. If the property value contains an equal sign ("="), ADO assumes you are providing a connection string rather than a DSN.

ADO supports five arguments for the ConnectionString property; any other arguments pass directly to the provider without any processing by ADO. The arguments ADO supports are as follows:




Specifies the name of a provider to use for the connection.

Data Source

Specifies the name of a data source for the connection, for example, a SQL Server database registered as an ODBC data source.


Specifies the user name to use when opening the connection.


Specifies the password to use when opening the connection.

File Name

Specifies the name of a provider-specific file (for example, a persisted data source object) containing preset connection information.

After you set the ConnectionString property and open the Connection object, the provider may alter the contents of the property, for example, by mapping the ADO-defined argument names to their provider equivalents.

The ConnectionString property automatically inherits the value used for the ConnectionString argument of the Open method, so you can override the current ConnectionString property during the Open method call.

Because the File Name argument causes ADO to load the associated provider, you cannot pass both the Provider and File Name arguments.

The ConnectionString property is read/write when the connection is closed and read-only when it is open.

Applies To


file: /Techref/language/asp/comp/daprop02_4.htm, 3KB, , updated: 1996/11/21 19:01, local time: 2022/8/9 07:52,

 ©2022 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?
Please DO link to this page! Digg it! / MAKE!

<A HREF=""> ConnectionString Property (ADO)</A>

After you find an appropriate page, you are invited to your to this massmind site! (posts will be visible only to you before review) Just type a nice message (short messages are blocked as spam) in the box and press the Post button. (HTML welcomed, but not the <A tag: Instead, use the link box to link to another page. A tutorial is available Members can login to post directly, become page editors, and be credited for their posts.

Link? Put it here: 
if you want a response, please enter your email address: 
Attn spammers: All posts are reviewed before being made visible to anyone other than the poster.
Did you find what you needed?

  PICList 2022 contributors:
o List host: MIT, Site host, Top posters @20220809
* Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated!
* Contributors: Richard Seriani, Sr.

Welcome to!