PRSQL9012021: ISQL Hangs Restoring Master Database

ID Number: Q67330

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9012021

SYMPTOMS

When loading the master database from a dump, ISQL hangs, and the

following error message is received:

DB-Library: Error in sending out-of-band data to SQL Server.

CAUSE

This problem occurs when using ISQL with network pipes by

connecting from a remote workstation or a local machine (for

example, "isql /U sa /P /S servername") to load the master

database. ISQL loads the master database correctly and shuts down

the SQL Server; however, ISQL appears to hang.

RESOLUTION

Connect to the SQL Server using ISQL via a local pipe; for example,

"isql /U sa /P". When this local pipe is used, ISQL exits with the

following error message:

DB-Library: Unexpected EOF from SQL Server.

This is expected behavior.