ADO ConnectionString Property

The ConnectionString property sets or returns the details used to create a connection to a data source.

Note: You can not use both the Provider and File Name parameters.



The ConnectionString property has these parameters:

Parameter Description
Provider The provider to use for the connection
File Name A provider-specific file that contains connection information
Remote Provider The provider to use when opening a client-side connection
Remote Server A path name of the server to use when opening a client-side connection
url An absolute URL identifying a resource, such as a file or directory


set conn=Server.CreateObject("ADODB.Connection")
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0" server.mappath("database.mdb")

Goto ADO Connection Object Complete Reference
ADO ConnectionString Property Reviewed by 1000sourcecodes on 08:47 Rating: 5
Powered by Blogger.