📄 met_stream_open.asp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>ADO Open Method</title>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />
<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<link rel="stylesheet" type="text/css" href="../stdtheme.css" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</head>
<body>
<a name="top"></a>
<table cellpadding="0" cellspacing="0" width="100%" bgcolor="#808080">
<tr>
<td width="234" valign="top">
<a href="../default.htm"><img src="../images/w3default80.jpg" border="0" alt="W3Schools" /></a>
</td>
<th valign="middle" align="left" class="right">
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txtimg*/
google_ad_slot = "5330033957";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript" src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<noscript>
<a href="../default.asp" target="_blank"><img src="../banners/w6.gif" border="0" alt="W3Schools" /></a>
</noscript>
<br /></th>
</tr>
</table>
<table style="margin-left:1px" width="800px" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="137" class="content" valign="top"><br />
<a class="left" href="../default.asp" target="_top">
<img src="../images/homeicon.gif" border="0" alt="home" /></a>
<a class="left" href="../default.asp" target="_top">
<b>HOME</b></a>
<br /><br />
<b>ADO Tutorial</b><br />
<a class="left" target="_top" href="default.asp" >ADO HOME</a><br />
<a class="left" target="_top" href="ado_intro.asp" >ADO Intro</a><br />
<a class="left" target="_top" href="ado_connect.asp" >ADO Connect</a><br />
<a class="left" target="_top" href="ado_recordset.asp" >ADO Recordset</a><br />
<a class="left" target="_top" href="ado_display.asp" >ADO Display</a><br />
<a class="left" target="_top" href="ado_query.asp" >ADO Query</a><br />
<a class="left" target="_top" href="ado_sort.asp" >ADO Sort</a><br />
<a class="left" target="_top" href="ado_add.asp" >ADO Add</a><br />
<a class="left" target="_top" href="ado_update.asp" >ADO Update</a><br />
<a class="left" target="_top" href="ado_delete.asp" >ADO Delete</a><br />
<a class="left" target="_top" href="ado_demo.asp" >ADO Demo</a><br />
<a class="left" target="_top" href="ado_getstring.asp" >ADO Speed Up</a><br />
<br />
<b>ADO Objects</b><br />
<a class="left" target="_top" href="ado_ref_command.asp" >ADO Command</a><br />
<a class="left" target="_top" href="ado_ref_connection.asp" >ADO Connection</a><br />
<a class="left" target="_top" href="ado_ref_error.asp" >ADO Error</a><br />
<a class="left" target="_top" href="ado_ref_field.asp" >ADO Field</a><br />
<a class="left" target="_top" href="ado_ref_parameter.asp" >ADO Parameter</a><br />
<a class="left" target="_top" href="ado_ref_property.asp" >ADO Property</a><br />
<a class="left" target="_top" href="ado_ref_record.asp" >ADO Record</a><br />
<a class="left" target="_top" href="ado_ref_recordset.asp" >ADO Recordset</a><br />
<a class="left" target="_top" href="ado_ref_stream.asp" >ADO Stream</a><br />
<a class="left" target="_top" href="ado_datatypes.asp" >ADO DataTypes</a><br />
<br />
<a class="left" target="_top" href="ado_summary.asp" >ADO Summary</a><br />
<br />
<b>Examples</b><br />
<a class="left" target="_top" href="ado_examples.asp" >ADO Examples</a><br />
<br />
<b>Exam</b><br />
<a class="left" target="_top" href="../cert/default.asp" >ADO Exam</a><br />
<br />
<b>Selected Reading</b><br />
<a class="left" target="_top" href="../browsers/browsers_stats.asp">Web Statistics</a><br />
<a class="left" target="_top" href="../site/site_glossary.asp">Web Glossary</a><br />
<a class="left" target="_top" href="../hosting/default.asp">Web Hosting</a><br />
<a class="left" target="_top" href="../quality/default.asp">Web Quality</a><br /><br />
<a class="left" target="_top" href="../forum/default.asp">W3Schools Forum</a><br /><br />
<a class="left" target="_top" href="../about/about_helping.asp">Helping W3Schools</a><br /><br />
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*LeftLinkUnit*/
google_ad_slot = "4854527104";
google_ad_width = 120;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td>
<td valign="top">
<table style="border: 1px solid gray" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="5" cellspacing="0">
<tr>
<td>
<h1>ADO Open Method</h1>
<hr />
<a href="ado_ref_stream.asp"><img class="navup" src="../images/up.gif" alt="Stream Object Reference" border="0" /> Complete Stream Object Reference</a>
<hr />
<p>The Open method is used to open a Stream object.
</p>
<h3>Syntax
</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<td valign="top">
<pre>objStream.Open source,mode,opt,username,psword</pre>
</td>
</tr>
</table>
<br />
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<th align="left" valign="top" width="20%">Parameter</th>
<th align="left" valign="top" width="80%">Description</th>
</tr>
<tr>
<td valign="top">source </td>
<td valign="top"> Optional. The data source for the Stream object (a URL that points to an existing node in a
tree structure, like an e-mail or file system or a reference to an already opened Record
object). If source is not specified, a new Stream object, with a size of
zero, will be created and opened
</td>
</tr>
<tr>
<td valign="top">mode </td>
<td valign="top"> Optional. A <a href="#connectmodeenum"> ConnectModeEnum</a> value that
specifies the access mode for a Stream object. Default is adModeUnknown
</td>
</tr>
<tr>
<td valign="top">opt </td>
<td valign="top"> Optional. A <a href="#streamopenoptionsenum"> StreamOpenOptionsEnum</a>
value that specifies options for opening a Stream
object. Default is adOpenStreamUnspecified
</td>
</tr>
<tr>
<td valign="top">username </td>
<td valign="top"> Optional. A name of a user who can access the Stream object. If
Source is an already opened Record, this parameter is not specified
</td>
</tr>
<tr>
<td valign="top">psword </td>
<td valign="top"> Optional. A password that validates the username. If Source
is an already opened Record, this parameter is not specified
</td>
</tr>
</table>
<br />
<hr />
<a name="connectmodeenum"><h3>ConnectModeEnum Values</h3></a>
<table cellpadding="3" width="100%" class="ex" cellspacing="0" border="1">
<tr>
<td valign="top" width="30%"><b>Constant</b></td>
<td valign="top" width="10%"><b>Value</b></td>
<td valign="top" width="60%"><b>Description</b></td>
</tr>
<tr>
<td valign="top">adModeUnknown</td>
<td valign="top">0</td>
<td valign="top">Default. Permissions have not been set or cannot be
determined</td>
</tr>
<tr>
<td valign="top">adModeRead</td>
<td valign="top">1</td>
<td valign="top">Read-only</td>
</tr>
<tr>
<td valign="top">adModeWrite</td>
<td valign="top">2</td>
<td valign="top">Write-only</td>
</tr>
<tr>
<td valign="top">adModeReadWrite</td>
<td valign="top">3</td>
<td valign="top">Read/write</td>
</tr>
<tr>
<td valign="top">adModeShareDenyRead</td>
<td valign="top">4</td>
<td valign="top">Prevents others from opening a connection with read
permissions</td>
</tr>
<tr>
<td valign="top">adModeShareDenyWrite</td>
<td valign="top">8</td>
<td valign="top">Prevents others from opening a connection with write
permissions</td>
</tr>
<tr>
<td valign="top">adModeShareExclusive</td>
<td valign="top">12</td>
<td valign="top">Prevents others from opening a connection</td>
</tr>
<tr>
<td valign="top">adModeShareDenyNone</td>
<td valign="top">16</td>
<td valign="top">Allows others to open a connection with any permissions</td>
</tr>
<tr>
<td valign="top">adModeRecursive</td>
<td valign="top">0x400000</td>
<td valign="top">Used with adModeShareDenyNone, adModeShareDenyWrite, or
adModeShareDenyRead to set permissions on all sub-records of the current
Record</td>
</tr>
</table>
<br />
<hr />
<a name="streamopenoptionsenum"><h3>StreamOpenOptionsEnum Values</h3></a>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3" height="134">
<tr>
<th width="30%" align="left" valign="top" height="19">Constant</th>
<th width="10%" align="left" valign="top" height="19">Value</th>
<th width="60%" align="left" valign="top" height="19">Description</th>
</tr>
<tr>
<td valign="top" height="18">adOpenStreamUnspecified</td>
<td valign="top" height="18">-1</td>
<td valign="top" height="18">Default. Opens the Stream object with default
options</td>
</tr>
<tr>
<td valign="top" height="19">adOpenStreamAsync</td>
<td valign="top" height="19">1</td>
<td valign="top" height="19">Opens the Stream object in asynchronous
mode</td>
</tr>
<tr>
<td valign="top" height="38">adOpenStreamFromRecord</td>
<td valign="top" height="38">4</td>
<td valign="top" height="38">Identifies the contents of the Source parameter
to be an already open Record
object. The default behavior is to treat Source as a URL that
points directly to a node in a tree structure. The default stream
associated with that node is opened.</td>
</tr>
</table>
<br />
<hr />
<a href="ado_ref_stream.asp"><img class="navup" src="../images/up.gif" alt="Stream Object Reference" border="0" /> Complete Stream Object Reference</a>
<br />
<hr />
<!-- **** SPOTLIGHTS 1 **** -->
<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->
<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />
<center>
<iframe style="background-color:#ffffff" src="../banners/aspallbannerframe.asp" height="60" width="468" marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
</center>
<hr />
<table>
<tr>
<td><img src="../images/diploma.jpg" alt="diploma" /></td>
<td> </td>
<td valign="top">
<h2>Get Your Diploma!</h2>
<p>W3Schools' Online Certification Program is the perfect solution for busy
professionals who need to balance work, family, and career building.</p>
<p>The <a href="../cert/default.asp">HTML Certificate</a> is for developers who want to document their knowledge of HTML, XHTML, and CSS.</p>
<p>The <a href="../cert/default.asp">ASP Certificate</a> is for developers who want to document their knowledge of ASP, SQL, and ADO.</p>
</td>
</tr>
</table>
<br />
<hr />
<!-- **** END SPOTLIGHTS **** -->
</td></tr>
<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='met_stream_open.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>
</table>
</td></tr>
</table>
</td>
<td width="145" align="center" valign="top">
<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=ado" height="1850" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>
</td>
</tr></table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -