Cisco Unified Communications Manager (CallManager)

BAT ERROR - [Microsoft][ODBC SQL Server Driver][SQL Server] The Cursor Was Not Declared

Document ID: 99885

Updated: Nov 12, 2007



The Bulk Administration Tool (BAT), a web-based application, lets you perform bulk transactions, such as add, update, or delete, on a large number of phones, users, and ports on a Cisco Catalyst 6000 FXS Analog Interface Module to the Cisco CallManager database. BAT also supports the insertion and deletion of Cisco VG200 gateways and ports. Previously a manual operation, BAT helps you automate the process and achieve much faster add, update, and delete operations. BAT also provides the Tool for Auto-Registered Phones Support (TAPS), an optional component of BAT.

This document describes this BAT error message and the necessary steps to troubleshoot it:

Error Number: 40002
Error Description:37000: [Microsoft][ODBC SQL Server Driver][SQL Server]
The cursor was not declared.



Cisco recommends that you have knowledge of these topics:

  • Cisco Unified Communications Manager (CallManager)

  • Bulk Administration Tool (BAT)

Components Used

The information in this document is based on these software and hardware versions:

  • Cisco Unified Communications Manager (CallManager) 4.x

  • Bulk Administration Tool (BAT) 5.x

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.


Refer to Cisco Technical Tips Conventions for more information on document conventions.


When You attempt to export phones from BAT, this error message displays:

Error Number: 40002
Error Description:37000: [Microsoft][ODBC SQL Server Driver][SQL Server]
The cursor was not declared.


In order to overcome this error, perform these steps:

  1. Uninstall BAT with an Add/Remove program.

    Note: Delete the folder C:\ciscowebs\BAT if it is not deleted while BAT is uninstalled.

  2. Reboot the server.

  3. Re-install BAT through CCMAdmin > Application > Install Plugins:

    1. Log on with administrator privileges to the system that runs the publisher database for Cisco CallManager.

    2. Choose Applications > Install Plugins. The Install Plugins window displays.

    3. Find the Cisco Bulk Administration Tool and double-click the setup icon.

    4. A standard Windows dialog box appears. You must choose whether to copy the BAT install executable to your system or run it from the current location.

      If an existent version of BAT is detected on the server, a prompt asks you to confirm the reinstallation or upgrade. In order to reinstall BAT or upgrade from a previous version, click OK.

    5. The Welcome screen displays. Click Next, and the Current Settings window displays.

    6. In order to install to the default location C:\CiscoWebs\BAT\, click Next. BAT installs to C:\ciscowebs\BAT\. You cannot change this path. The Start Copying Files window displays. Setup begins to copy the files.

    7. The Setup Complete window displays. You have successfully installed BAT.

    8. Click Finish to close Setup.

Related Information

Updated: Nov 12, 2007
Document ID: 99885