Low cost ecommerce web development India flash website design

The ConnectionString
After setting the mode, you must set the Connection object's
ConnectionString property. Although you must set this property each time
you open a new Connection object, you should define the connection string
(or strings) in your application's global.asa file as an application-level or
session-level variable. There are at least three reasons to define the connection
string in the global.asa file; it means you only have one place to check for
connection string problems, you can change the connection from one database
to another with minimal code changes during development, and you can copy
or move your application from one server to another very quickly.
The ConnectionString property is both simple and complicated. It has
several parts, all of which are optional, depending on which type of
connection string you're using, but typically, you specify the following:
§ Provider name
§ Name of the database server
§ Name of the database you want to use
§ User ID (UID) with which to connect
§ Password (PWD) for that user ID.