ADO Tutorial
ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed UpADO Objects
ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypesADO Summary
ADO Examples
ADO ExamplesADO Exam
ADO CertificateADO 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
%>
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
Your suggestion:
Close [X]
Thank You For Helping Us!
Your message has been sent to W3Schools.
Close [X]
