Appendix A: Installing Driver to Print Reports

Return to Index or go to Next page.(Appendix B).

This is a little difficult and long, but one day I might be able to afford a install program that will do this automatically. If you are using more than one of my programs that require printing reports then this need only be done once.

When printing from IE some pictures may be cut off at the bottom of the pages.

Before starting backup and make a restore point. You will need administrators rights. I have not been able to install this with Windows Vista (Part 2).

Part A

Installing the selected driver

Installing the driver.

1. Record where you installed the programs. The Default is C:\CMS
2. Click on the Start button and select Run, type regedit and press the OK button.

3. Expand the HKEY_LOCAL_MACHINE key.

4. Expand the SOFTWARE key.

5. Expand the ODBC key.

6. Expand the ODBCINST.INI key – These are the installed drivers that appear in the Drivers tab in the Data Sources window.

7. Right-click on the ODBCINST.INI key, move the mouse to New in the popup menu and select Key in the second popup menu. A new item will appear at the bottom of the list in the tree view and should be in edit mode.

8. Type VODBF and press enter.

9. You will now have one entry in the right hand list view that is named Default. (Past column)

10. The table below shows the entries that you need to add:

11. Right-click on the newly created VODBF folder, move the mouse to New in the popup menu and select String Value from the second popup menu. A new entry will appear in the list view.

12. If the new entry in the list view is not in edit mode, right-click on the new entry in the list view and select Rename.

13. Change the text to APILevel (this is the first entry in the list above) and press enter.

14. Right-click on the same entry and select Modify. A dialog displays the name of the item that you are editing and allows you to enter the required value.

15. Type 1 (the value for the first item in the list above) and press the OK button.

16. Repeat steps 11 to 15 for each of the entries in the list above.
NOTE – When doing the UsageCount entry in the list, for step 11 you must select DWORD Value from the New popup menu and NOT String Value. Also, for this entry in the list, there is no need for steps 14 and 15 because a DWORD Value is automatically set to 0.

Missing from the picture “File usage REG_SZ 1”
If these are incorrect edit the valves.

Having entered all of the details for the driver, you must put the driver into the installed list.

17. Look in the left hand tree view for the folder ODBC Drivers and click on it. The right hand list view shows the list that you actually see in the Drivers tab of the Data Sources dialog.

18. Right-click on the ODBC Drivers folder in the tree view, move the mouse to the New entry in the popup menu and select String Value from the second popup menu. A new entry will appear in the list view.

19. If the new entry in the list view is not in edit mode, right-click on the new entry in the list view and select Rename.

20. Change the text to VODBF and press enter

21. Right-click on the same entry and select Modify. A dialog displays the name of the item that you are editing and allows you to enter the required value.

22. Type Installed and press the OK button.

This completes the Driver installation so close regedit by selecting Registry / Exit from the menu.

Part 2

Adding a connection

Now that you have the driver installed you will need to make the named connection before you will be able to use it.

For the purpose of this document we will make a connection named LA.

The following instructions are for Windows XP, other version may have slight differences to get to the ODBC Data sources

1. Click on the windows start button in the botton left hand corner. Now click on the Control Panel, then on Performance & Maintenace, Administrative Tools, and then on Data Sources (ODBC) click on the drivers tab(A). If you have completed part A correctly then entry B (VODBF) will be listed. If not recheck part 1. (Windows Vista has not yet worked for part2).

(NOTE – VO people recommend using “System DSN” as it is more useful and reliable than User DSN, especially when several users could operate the machine. For this reason we will be going through the set-up of a System DSN connection but the steps are the same for a User DSN.)

2. Change to the System DSN tab.

3. Press the Add… button.

4. Scroll down the list, select VODBF as the driver and press the Finish button.

5. Set the Data Source Name: to LA and the type to Clipper. The other fields can be left blank. Click “Apply” and then “OK”.

6. You will now see the LA listed in the System DSN tab.

7. You can now close the Data Sources dialog.

This completes the setup of the connection and it is ready to use.

Confirming the install is correct, print a report from the program. The reports may not work if there is on information to print.