start
Welcome to Microsoft Business Solutions - Navision ODBC Driver Help

This file is used by the NODBC configuration dialog.


DSN
Insert a name for the new data source here. This name identifies the data source and you will see this name if you connect an application to a database using ODBC.


Description
This field allows you to enter an additional description for the data source.


DBPath
This is the path where your Navision files reside.

Example: c:\Program Files\Navision


DBPathButton
Use this button to choose a path to your Navision files.


Local
Check Local if you want to open a local database.


Server
Check Server to open a database using a server.


ServerName
Insert a server name here if you want to open a database using a server.


NetType
Choose the network type here to establish a server connection.


DB
Enter the database name including the path here.

Example: c:\Program Files\Navision\database.fdb


DBButton
Use this button to select a database.


Company
Insert the name of the company you wish to work with here. We recommend using the ‘Company…’ button to avoid misspelling.


CompanyButton
Use this button to see a list of all companies in your database.


UserName
Insert your user ID here.


Password
Insert your password here. If you have not been assigned a password, leave this field blank.


Options
Use this button to show more options for the driver.


Identifiers
Choose the character set used by the driver to convert database identifiers. This conversion is necessary because of the limitations of the Standard Query Language (SQL).


Language
Select the language used to retrieve multilanguage captions by the driver. ‘Neutral’ retrieves the names instead of the captions.


OptionType
Decide how Option fields are displayed (Text or Integer).


Commit
Enable or disable the Commit Cache here.


DBMSCache
Insert the cache size used by the database (0 to 30000). If zero is entered here, a default cache size of 8000 will be used.


Blob
Here you can choose whether to display binary fields (BLOBs).


RegionalDec
If you place a check mark in this field, the regional the Regional Decimal Symbol is used for Decimals. If you do not select this field a dot (.) is used.


Closing
Enables the Closing Date support. If you place a check mark in this field, date fields are displayed as DateTime fields. To enter a closing date, add the time 23:59:59 to a date field.


ReadOnly
If you place a check mark in this field, no data can be written into the database using the driver.


WindowsLogin
If you place a check mark in this field, user ID and password are disabled and Windows Login is used.


ImportLicense
Press this button to import a License file for the driver. The imported License is used to access a database.


Save
Press this button to save your changes and close the dialog.


Cancel
Press this button to discard your changes and close the dialog.


About
Opens the About dialog and shows your license information if a database and a company are selected.