Open topic with navigation

OLEDB.UserId Property

BarTender 2016 introduced new functionality to the Database object that eliminates the need for a separate OLEDB object. While the OLEDB object is still supported in BarTender 2016, you are encouraged to instead use the new properties of the Database object. It is possible that the OLEDB object will be deprecated in a future BarTender version.

ClosedDescription

Sets and returns the OLE DB data source user identification.

ClosedSyntax

OLEDB.UserId = ID

Where ID is the user name for access to the OLE DB data source.

ClosedRequirements

Version

BarTender 7.50 or higher

Edition

Automation, Enterprise Automation

ClosedRemarks

The OLEDB.UserId property sets and returns the user id for the selected OLE DB data source. If a user ID does not exist, then an empty string will be returned.

ClosedVB.NET Example

'Declare a BarTender application variable

Dim btApp As BarTender.Application

'Declare a BarTender document variable

Dim btFormat As New BarTender.Format

'Declare BarTender database variable

Dim btDb As BarTender.Database

'Create a new instance of BarTender

btApp = New BarTender.Application

'Set the BarTender application visible

btApp.Visible = True

'Open a BarTender document

btFormat = btApp.Formats.Open("c:\Format1.btw", False, "")

'Select the database

btDb = btFormat.Databases.GetDatabase(1)

'Set the user ID

btDb.OLEDB.UserId = "Administrator"

'Set the password

btDb.OLEDB.Password = "12345";

'End the BarTender process

btApp.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges)

ClosedC# Example

// Declare a BarTender application variable

BarTender.Application btApp;

// Declare a BarTender document variable

BarTender.Format btFormat;

// Declare a BarTender database variable

BarTender.Database btDb;

// Create a new instance of BarTender

btApp = new BarTender.Application();

// Set the BarTender application visible

btApp.Visible = true;

// Open a BarTender document

btFormat = btApp.Formats.Open("c:\\Format1.btw", false, "");

// Select the database

btDb = btFormat.Databases.GetDatabase(1);

// Set the user ID

btDb.OLEDB.UserId = "Administrator";

// Set the password

btDb.OLEDB.Password = "12345";

// End the BarTender process

btApp.Quit(BarTender.BtSaveOptions.btDoNotSaveChanges);

Related Topics