# MTXMLRowSet

The XML rowset supports retrieving tabular data remotely using the XMLHTTP object and the ADO XML support. The retrieved XML is then inserted into a local ADO object. This interface is very specific to the Microsoft ADO XML implementation.

## Program ID

Rowset.XMLRowset.1

## MTXMLRowSet Properties

ConnectionType | Gets/sets the type of connection (secure or normal).
HostName | Gets/sets the host name.
OverRideConnectionString | Manually specify a URL string instead of building one from a query file.
Password | Password to use in case authentication is required.
PortNumber | Port number of the remote connection.
UserName | Get or set the user name.

## Example

Example to be provided in a future release of this online help system.

# Property Detail

## ConnectionType

Gets/sets the type of connection (secure or normal).

### Visual Basic Syntax

Property ConnectionType As XMLRowSet_ConnectionEnum

### C++ Syntax

HRESULT ConnectionType([out, retval] XMLRowSet_ConnectionEnum* aType);

HRESULT ConnectionType([in] XMLRowSet_ConnectionEnum aType);

### Arguments

aType

The type of connection to create; secure or normal.

### Return Value

The type of connection.

## HostName

Gets or sets the host name.

### Visual Basic Syntax

Property HostName As String

### C++ Syntax

HRESULT HostName([out, retval] BSTR* pHostName);

HRESULT HostName([in] BSTR aHostName);

### Arguments

pHostName

The host name.

### Return Value

The host name.

## OverRideConnectionString

Manually specify a URL string instead of building one from a query file.

### Visual Basic Syntax

Property OverRideConnectionString As String

### C++ Syntax

HRESULT OverRideConnectionString([out, retval] BSTR* aOverRideString);

HRESULT OverRideConnectionString([in] BSTR aOverRideString);

### Arguments

aOverRideString

The URL to use.

### Return Value

TheURL of the connection.

## Password

Password to use in case authentication is required.

### Visual Basic Syntax

Property Password As String

### C++ Syntax

HRESULT Password([out, retval] BSTR* pPassword);

HRESULT Password([in] BSTR aPassword);

### Arguments

aPassword

The password to set.

### Return Value

Retrieves the password for this connection.

## PortNumber

Port number of the remote connection.

### Visual Basic Syntax

Property PortNumber As Long

### C++ Syntax

HRESULT PortNumber([out, retval] long* pPort);

HRESULT PortNumber([in] long port);

### Arguments

Port

The port number to set.

### Return Value

The port number of the connection.

## UserName

Get or set the user name.

### Visual Basic Syntax

Property UserName As String

### C++ Syntax

HRESULT UserName([out, retval] BSTR* pUserName);

HRESULT UserName([in] BSTR aUserName);

### Arguments

aUserName

The user name to set for the connection.

### Return Value

Retrieves the user name for this connection.