From http://www.w3schools.com (Copyright Refsnes Data)
Complete Connection Object Reference
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.
| objconn.ConnectionString="para1=value;para2=value;etc;" |
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" conn.open server.mappath("database.mdb") conn.close %> |
Complete Connection Object Reference
From http://www.w3schools.com (Copyright Refsnes Data)