Installing Resource 32000

The following instructions assume that you already have Resource 32000 correctly set up on your network. They are to be used when you acquire a new PC or when a PC has had Windows re-installed on it for some reason. Knowledge of administering Windows PCs is assumed in these instructions.

  1. Installing ODBC DriversEven if your PC already has the necessary ODBC drivers on its control-panel DSR strongly recommends following these instructions. This is because many versions of the ODBC drivers issued by Microsoft contain bugs which prevent Resource 32000 and/or IQ-Objects from working correctly.

    The program you need to run to install the ODBC drivers is called mdac_typ.exe. This file is usually in the following directory inside your main network Resource 32000 directory:

    Clients\Other….!!!!! (check the exact path)

    If mdac_type.exe is not in this location you should be able to find it elsewhere in the folders in your Resource 32000 directory, or on your Resource 32000 CD-Rom.

    Simply double-click on the mdac_typ.exe file to run it.

    You can either instal mdac 2.0 or mdac 2.1. The immediately following instructions refer to mdac 2.0. If you are installing mdac 2.1 then skip past the next section to the mdac2.1 installation instructions on the next page.

    Mdac 2.0 Installation

    On some Windows 95 computers you will be warned that DCOM95 is missing. You can ignore this message and continue with the ODBC installation. The file DCOM95.exe is available in the Resource tree if you would like to install it, which you do simply by double-clicking on it.

    Request “Custom Installation?

    MDAC_TYP 2.0 installs two different database access technologies, ODBC and OLE DB. You will usually only want ODBC so you should only leave 3 of the boxes checked. These three boxes are ODBC Components, SQL Server ODBC Drivers (only required if you want to access SQL Server databases), and MS-Access ODBC drivers. All the OLE DB boxes and other components can be un-checked. As you do this you will be warned that you are removing “essential? parts of the application but they are not essential if you are only installing ODBC.

    Click the “Continue? button.

    You will then be asked if you want to enable “Remote Data Services?. Reply “No?.

    The ODBC drivers should now install. You may be requested to reboot the machine to complete the installation.

    Mdac 2.0 installation is now complete.

    The following section describes mdac 2.1 installation. Skip this section if you have already successfully installed mdac 2.0

    Mdac 2.1 Installation

    On some Windows 95 computers you will be warned that DCOM95 is missing. You can ignore this message and continue with the ODBC installation. The file DCOM95.exe is available in the Resource tree if you would like to install it, which you do simply by double-clicking on it.

    Request “Custom Installation?

    Select ODBC Components, Access, and SQL Server drivers.

    Click the “Continue? button.

    The ODBC drivers should now install. You may be requested to reboot the machine to complete the installation.

    Mdac 2.1 installation is now complete.

  2. Install Sybase client softwareSkip this stage if you are not using a Sybase database. Run the setup.exe program on your Sybase CD and choose the options to install client software. This procedure is straightforward. Simply follow the screen prompts.
  3. Set up ODBC Data SourcesGo into control panel and select the “ODBC data sources? application. All your data sources should be added onto the “System DSN? tab so select this tab. Do not create data sources of the same name on both the User DSN tab and the System DSN tab because doing so confuses ODBC.

    Use an existing Resource 32000 client PC as an example of correct setup if you are unsure of how to proceed at this stage.

    You will need to add an Access data source for each database, regardless of the actual database platform. This Access data source should have the same name as the database it points at, but without the .mdb extension. So if you have a database called “MyCompany.mdb? then create an Access datasource called “MyCompany? and use the “Select…? button to point the data source at the correct database. If you have a SQL Server or Sybase database called MyCompany then create an Access data source called MyCompanyIQ and point it at MyCompanyIQ.mdb in the Data directory inside your network Resource 32000 folder.

    If you are running a SQL Server or Sybase database then you need to add a data source that points at that database. The datasource must have the same name as the database (ie if the database is called MyCompany then the data source should be called MyCompany). Both Sybase and SQL Server use multi-page dialogs to define the details of the ODBC link. Copy the details of these dialogs from one of your other PCs which is already correctly set up.

    At the end of the process you will have one Access data source for each for your databases, and one client-server data source for each of your SQL Server or Sybase databases.

  4. IQ InstallationPlease note that you should not install IQ on more PCs than the number of licences that you have purchased. To do so is a violation of the terms of your licence to use IQ.

    There is a directory in your network Resource 32000 area called IqObjects. This contains folders called “Per32? and “Adm32?. Use Per32 if this PC is only going to run IQ Personal Edition to run reports. Use Adm32 if this PC is going to be used to write or modify IQ Reports. These folders contain a folder called “Disk1? which contains a program Setup.exe.

    Run Setup.exe by clicking on it……

    Installing Personal Edition (Per32\disk1\setup.exe)

    Accept the licence terms.

    Choose Custom Installation, you will be prompted to place the IQ software on c:\iq\iqobject which you should always accept.

    Remove all the ODBC driver options that you can from the list that appears.

    Follow the prompts through to the end.

    Installing Reporting Edition (Adm32\disk1\setup.exe)

    Accept the licence terms.

    Choose Custom Installation, you will be prompted to place the IQ software on c:\iq\iqobject which you should always accept.

    Enter the licence key, you can get this from another machine which has had reporting edition installed by going into IQ-Objects and selecting Help, Activation Key… on the menu. To make it easier to enter this key you might use copy (Ctrl-Ins) and paste (Shift-Ins) to get the key into a text file, then you can open this text file on the machine you are installing, and use copy and paste again to enter the key into the installation program.

    Select the components that you wish to install. You will definitely need “Query Designer?. Reporting Edition automatically includes Personal Edition.

    Remove all the ODBC driver options that you can from the list that appears.

    Follow the prompts through to the end.