ODBCUserName (Property)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

WLanguage properties

Properties associated with reports and controls

ODBCUserName

Presentation

Example

What is a query performed on a connection?

Properties used to manage reports based on data files accessed via an ODBC driver or via a Native Access

Limit

See also

ODBCUserName (Property)

In french: ODBCNomUtilisateur

Available only with these kinds of connection

What is a query performed on a connection?

A query performed on a connection is a query performed on data files handled via a specific ODBC driver or via a Native Access.

When the connection is created, you have the ability to define:

the connection name
the name of data source
the user name and password
the name of database accessed (if there is more than one).

The report editor allows you to print the data coming from a query performed on a connection. All the parameters of the connection to use can be defined in the report editor or by programming with the WLanguage properties.

..ODBCUserName is used to:

Find out the user name that was used to connect to a database via an ODBC driver or via a Native Access. This name must be specified when printing a report based on a "query performed on a connection".
Specify the user name that was used to connect to a database via an ODBC driver or via a Native Access. This name must be specified when printing a report based on a "query performed on a connection".

Remark: this property must be used in the opening code of report.

Example

// -- Opening code of report
RPT_Report1..ODBCConnectionName = "MyConnection"
RPT_Report1..ODBCSQLCode = "Select * FROM Products"
RPT_Report1..ODBCUserName = "MOORE"
RPT_Report1..ODBCPassword = "PSW"

Syntax

Finding out the user name that was used to connect to a database via an ODBC driver or via a Native Access Hide the details

<Result> = <Report name>..ODBCUserName

<Result>: Character string

User name defined in the report in order to connect to a database via an ODBC driver or via a Native Access.

<Report name>: Character string (with or without quotes)

Name of report to use.

Specifying the user name that was used to connect to a database via an ODBC driver or via a Native Access Hide the details

<Report name>..ODBCUserName = <New name>

<Report name>: Character string (with or without quotes)

Name of report to use.

<New name>: Character string (with quotes)

User name used to connect to a database via an ODBC driver or via a Native Access. This name must correspond to the user name defined when the connection was created in the administrator of the ODBC driver or Native Access.

Remarks

Properties used to manage reports based on data files accessed via an ODBC driver or via a Native Access

The following properties are used to manage reports based on fdata iles accessed via an ODBC driver or via a Native Access:


ODBCSQLCode	Used to find out and modify the SQL code of the query performed on a database accessed via an ODBC driver or via a Native Access.
ODBCPassword	Used to find out and modify the password associated with the user allowed to access a database via an ODBC driver or via a Native Access.
ODBCDatabaseName	Used to find out and modify the name of the database used by the query performed on a database accessed via an ODBC driver or via a Native Access.
ODBCConnectionName	Used to find out and modify the name of the connection used to access a database via an ODBC driver or via a Native Access.
ODBCUserName	Used to find out and modify the name of the user allowed to access a database via an ODBC driver or via a Native Access.

Limit

..ODBCUserName only applies to the reports based on a "query performed on a connection".