How to install the software?

If you have ever tried to install an application but instead been greeted by the “Certificate error. Contact the application supplier” message

The solution is easy. You can find the application manager in the tools folder, then click on "Option" to bring up "Settings"
Simply switch the setting in the Application Manager from "Signed only" to accept all - "Software Installation: All".
Another common issue is the "Expired Certificate " error. The certificate that the developer used may have expired. However, there is an even easier fix for this issue.
	Simply set the date on your device back one year and then install the application.
After you successfully installed the application don't forget to set the time correctly on your device.

“ConnAPI.dll not found. Try reinstalling the application

Uninstall all Nokia software, especially “PC Connectivity Solution” - the problem is caused because of it. Then, reinstall Nokia PC Suite and everything will be all right.

What is Database Synchronization Profile?

While creating a profile please ensure that you created profile for the same user for which you are syncing. Ensure that you have installed Database Viewer plus handheld application. After creating profile, synchronize your device with desktop. Open handheld Database Viewer plus application, you will get profile name in available profile list.

How do I keep Desktop database synchronized with Handheld device?

	Start Desktop DBViewerPlus
	Create a new profile
	Select profile property as "Desktop to Device"
	Synchronize
	Use desktop or handheld database as usual
	If you made modifications at handheld end and want to transfer it on desktop then, Open desktop Profile and set "Keep Sync" property to "Device to Desktop" and Synchronize
	If you made modifications in desktop database and want to transfer it on handheld then, Open desktop Profile and set "Keep Sync" property to "Desktop To Device" and Synchronize

How do I stop Desktop database & Handheld database synchronization?

From desktop DBViewerPlus, select a profile which you want to stop from synchronization, Open profile properties and select "Do not Sync" option for "Keep Sync" property.

What is DSN/ODBC Database?

DSN or Data Source Name is a way of Database connectivity through ODBC. Database Viewer Plus allows you to connect to ODBC database using DSNs available on your machine. You can create/manage DSNs on your machine. For that, Click on Config button in Database Selection dialog or onyourmachine, clickStart->[Settings]->Control Panel->[AdministrativeTools]->Data Sources (ODBC)

What are filters and How to Apply filters?

While creating Database Profile, you may want to transfer only selected record contents on handheld. Here, you can apply filters i.e. condition on record contents to transfer on to handheld. Open Apply Filters dialog, Check mark the filters for those you want. Select database field on which you want to apply filter, select appropriate filter operator and enter the filter condition value. You can apply one or more filters. To apply more than one filter, you must select joining in between two filters i.e. "AND" or "OR".
Remember, you must set proper filter value as per field selection. If you selected numeric field, say ID, then filter value must be numeric, say 35. For character data type filter value must be included in single quotes ('). For date/time fields, filter value must be in #.
If you want, you can manually enter filter condition in SQL query instead of using "Apply Filters" dialog. In SQL query, at the end, put "Where filter conditions" by removing earlier condition, if any.

Here are some examples of filters.

name = 'John'
amount >= 2000
birthdate = #1/1/1978#
time >= #2:10#
birthdate >= '1-jan-1978'

Note: Using # for filter conditions may change depending on which database you are using. MS Access, Excel allows to uses # where as Oracle, SQL Server allows to use single quote (') for date filter values.

SQL Query Example : Where name='John' and birthdate > #1/1/1978# or EmpID > 15
For Oracle/SQL Server: Where name='John' and birthdate > '1-jan-1978' or EmpID > 15

How to Apply Sort Orders?

You may want handheld database contents in some particular order. Using Database Viewer Plus you can apply "Sort Orders" on record contents. Open "Sort Orders" dialog box, Select field on which to sort and select sort order either "Ascending" or "Descending". You can apply more than one sort orders at a time.

 What are ways to connect to Excel Database?

DBViewer Plus offers two ways to get connected with Excel Database using file browsing. When you browse a Excel file, DBViewer Plus will ask prompt with "Excel Connection" dialog, asking you to View as a "View First Row as a Column Header" and view as a "Excel Worksheet".
Using ODBC Excel connection, will allow you to work on user defined tables. Where as Using Worksheets will allow you work on Entire Worksheets available in Excel file.

 What is SQL Query?

SQL Query directs what contents from connected database to synchronize with handheld device. Using "Build Query" dialog user can select tables, fields, filters, sort orders which is summarized in terms of SQL query, which DBViewer Plus uses to fetch data. What ever changes you made on database, tables, fields, filters, sort orders etc, finally all these will get reflected in SQL query. So, if user has some SQL knowledge, he can directly modify SQL query to get expected data. Use can enter any valid SQL Select query, which may include table joining, filtering, sorting, grouping etc

 What are Sync Option?

Sync Options, means the way by which your database contents will transfer. Using "Desktop to Device" your desktop database contents will transfer to handheld Database while synchronizing. Using "Device to Desktop", handheld database contents will flow from Handheld to desktop. "Do not sync" will disable profile from transferring data. At any time, you can switch among these options. For "Handheld to Desktop" sync option will be allowed for those profiles which have selected only one table and all fields from that table.

 I deleted a profile from handheld, at synchronization it gives me error "could not open handheld database". What can I do?

Using desktop DBViewerPlus, set this profile to transfer data from "Desktop to Device". On next synchronization, this profile will get transferred on handheld.

 I applifed filters on database profile, on preview, it gives me Invalid Query error message. What can I do?

While applying filters, you must take data types of field into consideration. Filter value for character must be included in single quote('). Also date field filter value must be in proper date format included in single quote or # depending selected database. For more information see filter help in user guide.

 What is difference between Excel WorkSheet & Excel ODBC Connection?

	Excel ODBC Connection create a connection between Desktop Excel and handheld as a ODBC database. Here you can SQL queries to filter result. However, if excel contents doesn't fit in Database Table criteria in this case only those contents which are valid will get transferred on handheld and rest contents are ignored. In such case, while synching from Handheld to Desktop, you may lose some data.
	Excel Worksheet connection allows user to transfer excel contents as is to handheld device. It will be treated as a text data. Each and every column is treated as text and not as corresponding data type such as date/time/number etc.

 I created a profile, and synchronized but it doesn't appear on my handheld, What should I do?

Using desktop DBViewerPlus, set this profile to transfer data from "Desktop to Device". On next synchronization, this profile will get transferred on handheld.

 I put in the registration key to the Mobile Database Viewer Plus application and it says invalid registration key.

We generate the registration key based on your "User ID".  If you are unregistered user, you can even invoke the Register dialog by selecting the Register menu option from the home screen of Database Viewer Plus application.

 On device side , you can register Database Viewer Plus at any time by entering the registration key that you have got & just press the Enter key.

If still  you have had problems regarding registration, Please send us "UserID.txt"  file which is at " c:\\" on support@cellica.com.