Problem with textcopy on SQL Server 2000 machine

• Swirly

  SSC Enthusiast

  Points: 113

  More actions

  January 14, 2010 at 4:15 am

  #214512

  Dear All,

  I am having a problem with the textcopy utility on a live SQL Server 2000 database on a named instance. The problem I am seeing is when I execute the textcopy utility locally; as follows; to download a file from the database to a file on my server:

  c:\textcopy /s "Server\Instance" /u "User" /p "Password" /d "dbDTS" /t "TblTopic" /c "outline"

  /w "where topicid = 144" /o /f "c:\Outlines_Temp\Outline.pdf"

  I get the following response:

  TEXTCOPY Version 1.0

  DB-Library version 8.00.194

  ERROR: Could not connect to SQL Server 'Server\Instance'

  When I try the same command on a remote server (ie still pointing at "Server\Instance") it works fine and downloads my file.

  My thinking so far is that this is to do with the ntwdblib.dll library, as the isql command (which I believe also uses the ntwdblib.dll library) also doesn't work locally, but does remotely; however I don't get any errors, it just returns nothing, ie (excerpt from cmd window):

  C:\Documents and Settings\user>isql -S "Server\Instance" -U "User" -P "Password" -d "dts"

  C:\Documents and Settings\user>osql -S "Server\Instance" -U "User" -P "Password" -d "dts"

  1> exit

  C:\Documents and Settings\user>

  In the above excerpt. you can see that the ISQL command returns nothing, but the OSQL command (which I don't think uses ntwdblib.dll) does work, which is why I think that the ntwdblib.dll may be involved in the problem.

  I have a copy of the database in question on a sql server 2000 development server in both a named instance and the default instance. The textcopy and isql functions both work locally on this development server. Both textcopy.exe and ntwdblib.dll appear to be the same version on the live and development servers.

  Anybody got any ideas or seen something like this before? COuld this have something to do with server or client networking settings? if so, any idea which settings?

  Thanks in anticipation!

  Paul Le Sueur.