|
|
ADO ConnectionString Property
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.
Syntax
|
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 |
Example
<%
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
The Creators of XMLSpy are Pleased to Announce
|
|
|