Pocket Database Viewer Plus(Access,Excel,Oracle) - User Guide and FAQ

Download Site 1       Download Site 2       Download Site 3       Buy Now $19.95

Frequently Asked Questions - Pocket Database Viewer Plus(Access,Excel,Oracle)

1. What is Difference between Database Viewer, Datasbase Viewer Plus and Database Converter?
   Database Viewer: Database Viewer allows desktop database contents to transfer and view on palm.
   Database Viewer Plus: Database Viewer Plus keeps desktop and palm database in synchronization mode. Allows desktop contents to transfer on palm and vice versa. Allows to add/modify/delete contents on palm.
   Database converter: It's Palm OS developer utility program. It converts desktop database in palm standard pdb format, allowing developer to access and manipulate pdb contents programmatically.



2. 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.



3. How do I keep Desktop database synchronized with Handheld device?
   Start Desktop DBViewerPlus
   Create a new profile
   Select profile property as "Desktop to Handheld"
   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 "Handheld 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 Handheld" and Synchronize



4. 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.



5. 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 on your machine, click Start->[Settings]->Control Panel->[Administrative Tools]->Data Sources (ODBC)



6. 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 "ODBC database" 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.



7. 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



8. 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.