Unregistering the ODBC drivers installed in Tally.ERP 9 folder

Discussion in 'Knowledge Base' started by admin, Mar 18, 2015.

    
  1. admin

    admin Administrator Staff Member


    Query

    How do I unregister the ODBC drivers installed in my Tally.ERP 9 folder?

    Answer

    By default, Tally.ERP 9 installs an ODBC driver of the same bitness on startup and uninstalls the same, on quitting. This driver can be used by an ODBC client (like the Microsoft Office - Excel) of the same bitness. There is no manual intervention required in this case.



    A user may install the ODBC driver (tallywin32.dat or tallywin64.dat) manually to enable export of data via ODBC, when the bitness of Tally.ERP 9 and the Microsoft Office (in a 64-bit Operating System) is not the same.

    For information on Installation of ODBC drivers for effective export of data via ODBC, click here.

    Note: ODBC drivers can be installed either in the default port (fetched from the tally.ini file) or using a different port.

    In order to unregister the ODBC drivers, the procedure to be followed is explained below using two scenarios:


    Scenario 1: The user has installed the ODBC driver using the default port

    If the user has installed the ODBC driver using the default port (mentioned in the tally.ini file), then follow the given steps.

    • Go to Start

    • Select Run

    • Type cmd and press Enter to open the Command Prompt

    • Type the following command to unregister the ODBC drivers,

      • If 32-bit ODBC driver was installed:
        <Tally.ERP 9 64-bit application folder path>regodbc32.exe /UNREGISTER

        Or


      • If 64-bit ODBC driver was installed:
        <Tally.ERP 9 32-bit application folder path>regodbc64.exe /UNREGISTER

    • Press Enter.

    The ODBC driver will now be unregistered.

    For example: If the Tally.ERP 9 application folder path is C:tally and 32-bit ODBC driver was installed with 64-bit Tally.ERP 9, then the command to be entered in the Command prompt would be:


    C:tallyregodbc32.exe /UNREGISTER

    [​IMG]

    On pressing Enter, the following message will be displayed.

    Server at port: 9000 Unregistered

    ~KBIMG=10643~

    Scenario 2: The user has installed the ODBC drivers using a port different from that of the default port

    If the user has installed the ODBC driver using a different port, then to unregister, the following command has to be entered in the command prompt.

    • If 32-bit ODBC driver was installed (with 64-bit Tally.ERP 9 application):
      <Tally.ERP 9 64-bit application folder path>regodbc32.exe /UNREGISTER PORT

      Or


    • If 64-bit ODBC driver was installed (with 32-bit Tally):
      <Tally.ERP 9 64-bit application folder path>regodbc64.exe /UNREGISTER PORT

    For example: In the Tally.ERP 9 application folder - C:tally, if a 64-bit ODBC driver was installed with 32-bit Tally.ERP 9 and the port used to install the ODBC driver is 10000, then the command to be entered in the Command prompt would be

    C:tallyregodbc64.exe /UNREGISTER 10000


    [​IMG]



    On pressing Enter, the following message will be displayed



    Server at port: 10000 Unregistered


    [​IMG]
     


Share This Page