DevGuru ADO Stream::Open Method

Quick References

Features

Partners

METHOD: Stream::Open

Implemented in version 2.5

streamobject.Open Source, Mode, OpenOptions, UserName, Password

The Open method is called to open a Stream object. While the Open operation is occurring, you temporarily cannot set any properties until the open is completed. Remember, prior to opening a Stream, you can access the various read-only properties and obtain values.

There are five optional parameters.

The optional Source parameter is a variant that indicates the source of the data for the Stream object. This can be a URL or a reference to an already opened Record object. If you do not specify a source, a new Stream will be created and opened. It will have a Size of zero and will contain no data since it will not be associated with any underlying source.

The optional Mode parameter is one of the ConnectModeEnum constants that dictate the access permissions for a Stream object. If the Source parameter is an already opened Record object, this parameter will be implicitly set.

ConnectModeEnum Constants

Constant	Value	Description
adModeRead	1	Read-only permission
adModeReadWrite	3	Read/write permission
adModeRecursive	0x400000	Sets permissions for children of the Record. Must use with either: 1. adModeShareDenyRead, 2. or adModeShareDenyWrite, 3. or adModeShareDenyNone plus any one of adModeRead, adModeReadWrite, or adModeWrite
adModeShareDenyNone	16	Other users can open a connection with all permissions
adModeShareDenyRead	4	No other user can open a connection with read permission
adModeShareDenyWrite	8	No other user can open a connection with write permission
adModeShareExclusive	12	No other user can open a connection
adModeUnknown	0	Default, permission not set or determined
adModeWrite	2	Write-only permissions

The optional OpenOptions parameter is a StreamOpenOptionsEnum constant that specifies possible options for opening a Stream object.

StreamOpenOptionsEnum Constants

Constant	Value	Description
adOpenStreamAsync	1	Open in an asynchronous mode
adOpenStreamFromRecord	4	Already opened Record
adOpenStreamUnspecified	-1	Use the default

The optional UserName parameter is a string containing the name of a user who can access the Stream object. If the Source parameter is an already opened Record, neither the UserName nor the Password parameter is used.

The optional Password parameter is a string containing the password that validates the UserName parameter. If the Source parameter is an already opened Record, neither the UserName nor the Password parameter is used.

Code (VBScript):
objStream.Open rsGuruData, adModeReadWrite
objStream.Position = 0
...
objStream.Close