Difference between revisions of "Lianja ODBC Manager on Windows"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 96: | Line 96: | ||
[[{{ns:file}}:Logging.png|150px|thumb|left|Logging tab]] | [[{{ns:file}}:Logging.png|150px|thumb|left|Logging tab]] | ||
− | + | <br clear=all> | |
==Windows ODBC Administrator== | ==Windows ODBC Administrator== | ||
[[{{ns:file}}:ServiceManager.png|150px|thumb|left|Service Manager tab]] | [[{{ns:file}}:ServiceManager.png|150px|thumb|left|Service Manager tab]] |
Revision as of 12:40, 28 January 2013
Contents
See Also
Lianja SQL Server Manager, 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.
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.
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
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 '?'. |
Password | Password for the above account on the server. For the local server, this can be '?'. |
DATABASE or DIRECTORY | DATABASE: The name of the database on the server. DIRECTORY: The directory path where free tables are stored. |
Settings
Additional optional settings can be configured here.
Section | Item | Description |
---|---|---|
Scripts | Script | Script name |
Status | Service status: Stopped, Started | |
Startup Mode | Service startup mode: Manual, Automatic. | |
Buttons | New... | Create a new script. |
Edit... | Edit the selected script. | |
Delete | Delete the selected script. | |
Mode (Automatic or Manual) | Toggle the startup mode of the selected script between Automatic and Manual. | |
Refresh | Refreshes the display | |
Status (Started or Stopped) | Toggle the status of the selected script between Started and Stopped. |
Logging
Windows 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).