Lianja ODBC Manager on Windows

From Lianjapedia
(Redirected from Lianja ODBC Manager)
Jump to: navigation, search

See Also

Lianja ODBC Driver on Linux, Lianja ODBC Driver on Windows, Lianja Server Manager on Linux, Lianja Server Manager on Windows, SQL System Tables

The Lianja ODBC Manager

The Lianja ODBC Manager allows you to create, edit and delete Lianja ODBC data sources. It can be accessed from its desktop shortcut or from the Windows Start Menu under Lianja.

Start Menu

User Account Control

If you have User Account Control enabled, please click Yes on the UAC dialog displayed when you run the Lianja ODBC Manager. On Windows XP, please run the Lianja ODBC Manager as the Administrator.


The Lianja ODBC Manager is used for Lianja ODBC Driver data sources only. If you want to create or manage data sources for other ODBC Drivers for use from Lianja, do this in the 32 bit Windows ODBC Adminstrator.

Lianja ODBC Data Source Manager

Lianja ODBC Data Source Manager

The Lianja ODBC Data Source Manager displays your currently configured data sources:

  • Data Source Name (DSN)
  • Type (System, User, File)
  • Description

The buttons give you access to the following operations:

Operation Description
Delete Delete the currently selected DSN.
Add Configure a new DSN.
Edit Configure the currently selected DSN.
Close Close the Lianja ODBC Manager.

Choosing either of the Configure operations displays the Lianja DSN Configuration dialog.

Lianja DSN Configuration

The Connection Information tab contains all the standard configuration details. The optional Settings and Logging tabs are for optional settings.

Connection Information

Connection Information tab

Note: The Lianja SQL Server product distribution, which includes the Lianja ODBC Driver, comes with a fully-configured DSN to the southwind sample database on the local machine.

The following settings can be configured:

Setting Description
DSN Unique data source name.
Description Description of data source.
Server Host name or IP address of Lianja SQL Server.
User User name of valid account on the server. For the local server, this can be '?'. From v5.0 this must be a valid Lianja user.
Password Password for the above account on the server. For the local server, this can be '?'. From v5.0 this must be the password for the Lianja user above.
DATABASE or DIRECTORY DATABASE: The name of the database on the server. DIRECTORY: The directory path where free tables are stored.

From Lianja v5.0 Lianja Users and Roles are used to authenticate ODBC clients on the Lianja Server.
This means that Row level Security and Dynamic Data Masks are also applied to Lianja data accessed via ODBC.

Connection Diagnostics

To test the connection, click Apply to apply your settings, then click Diagnostics... to open the Lianja ODBC Diagnostics window and click Test in the Configuration dialog to run the test.


Settings tab

Additional optional settings can be configured here:

Section Setting Description
Database Row ID Include the rowid (number identifying the row’s physical stored position in the table) in results.
Readonly Open tables in noupdate mode.
Exclusive Open tables in exclusive mode.
Login Encryption Open tables with DES3 encryption key specification required.


Logging tab

Client and server logging and ODBC tracing can be enabled and configured here.

Section Setting Description
Client Enable Logging Check to enable client-side logging.
Enable Tracing Check to enable client-side tracing.
Log To File Name of log file. The Browse button allows the file to be selected, the View button the file to be viewed.
Server Logging Check to enable server-side logging.
Name Name of server-side log file.

Windows ODBC Administrator

ODBC Administrator

Lianja ODBC data sources can also be managed using the Windows ODBC Administrator. Please note that on 64 bit systems, the 32 bit ODBC Administrator should be used (%windir%\SysWOW64\odbcad32.exe).