X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR BOOTSTRAP XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

ADO ConnectionString Property


Connection Object Reference 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
%>


Connection Object Reference Complete Connection Object Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates

SHARE THIS PAGE

facebook