You can install the QUCM ODBC Query Service on your PC by following the instructions below. First, you need to set up a Data Source Definition to access your databse. The Data Source is required on the computer that will run the QUCM ODBC Query Service. This may or may not be the same machine that is running SQL Server. Open the Control Panel. Open "Administrative Tools" Open "Data Sources (ODBC)" Choose the "System DSN tab" Click the "Add..." button. Choose the appropriate driver, in this case it will be "SQL Server" If a driver for your database is not listed, you must obtain it from the database vendor or from Microsoft. Click "Finish" Give the Data Source a unique Name, say "Niobrara QUCM" And the description should be descriptive, say "QUCM Access to Northwind" Choose the SQL server. It should show up in the drop-down box, but you may need to type it in depending on the network setup. In this case, it is "TECHSERVER" Click "Next" Choose the appropriate authentication method and credentials. Ask your DB administrator for this information. In our test case, choose "SQL Server Authentication" Click the "Client Configuration" button. In the "Edit Network Library Configuration" dialog box, you must choose the network library and associated parameters for your server. In our case, choose the "TCP/IP" network library. If the QUCM ODBC Query Service is running on the same machine as SQL Server, you would normally use "Named Pipes" Put "TECHSERVER" in for the Computer Name and put 1035 in the port number. Click OK. You should be back to the "Create a New Data Source to ..." dialog box. You can uncheck "Connect to SQL Server to obtain default settings" Click "Next" Check "Change the default database to" and enter the name of the database, in this case "Northwind" Other settings can remain at defaults. Click "Next" Click "Finish" Now you have a chance to test the data source. Use it! Until you get this test to pass, there's no point in trying to run the QUCM ODBC Query Service. Click "OK" Now you have a Data Source. NOTE: The ODBC_SETUP.EXE program will automatically add the following registry entries. Next, we make the registry entries that configure the QUCM ODBC Query Service. You can run the attached QUCM-ODBC.reg file for the example. The keys are found in HKEY_LOCAL_MACHINE\SOFTWARE\Niobrara R&D\QUCM ODBC\ and are as follows: Data Source - string value - name of the data source, e.g. "Niobrara QUCM" User Name - string value - user name to access the database, e.g. "sa" Password - string value - password to access the database, e.g. "" If there is no password, this key must still be present but should be an empty string. TCP Port - DWORD value - TCP port the QUCM will be connecting to, e.g. 23 Allow IP - string value - TCP address for allowed connections, e.g. "206.223.51.0" Allow Mask - string value - TCP mask for allowed connections, e.g. "255.255.255.0" Now run the program qucmodbc.exe by "Start, Programs, Niobrara, ODBC Server, Start QUCM ODBC Server". It displays a console box with lots of helpful messages. This will soon be replaced by a GUI. The ODBC_SETUP program adds an entry to the registry to make the program run at startup. First, you can edit this string value to the registry key: HKEY_LOCAL_MACHINE\SOFWTARE\Microsoft\Windows\Current Version\Run The name of the value could be "QUCM ODBC" and the value of it should be the path to qucmodbc.exe