While using the BusinessConnect archiver, an exception is generated related to Isql.exe.

While using the BusinessConnect archiver, an exception is generated related to Isql.exe.

book

Article ID: KB0088675

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect -
Not Applicable -

Description

Resolution:
Description
==========
While executing archive.bat with SQL 2005, the following exception is thrown:

[ERROR] Error during archiving: Utility 'isql' at ../Microsoft SQL Server/100/Tools/Binn/' is not installed or cannot be found.

Environment
==========
All versions

Resolution
==========
Isql.exe is no longer supported and SQLCMD.exe replaces both isql and osql.

Suggested workaround:

1). Make a copy/backup of your SQLCMD.EXE in binn folder.

2). Rename SQLCMD.EXE to isql.exe.

3). Go to ...\Binn\Resources\1033 directory and take backup of osql.rll file.

4). Rename osql.dll to isql.dll.

5). Try to execute archive.bat.

Issue/Introduction

While using the BusinessConnect archiver, an exception is generated related to Isql.exe.