Posted by Connie on 03/08/07 18:56

On Mar 8, 12:23 pm, "Connie" <csaw...@rwbaird.com> wrote:
> On Mar 7, 4:46 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
>
>
>
>
>
> > Connie (csaw...@rwbaird.com) writes:
> > > Erland, The reason I am doing this is to extract a blob from a sql
> > > server table and store it into a location on our server. Here is what
> > > is in the sp_textcopy:
> > > CREATE PROCEDURE sp_textcopy (
> > > @srvname varchar (30),
> > > @login varchar (30),
> > > @password varchar (30),
> > > @dbname varchar (30),
> > > @tbname varchar (30),
> > > @colname varchar (30),
> > > @filename varchar (30),
> > > @whereclause varchar (40),
> > > @direction char(1))
> > > AS
> > > DECLARE @exec_str varchar (255)
> > > SELECT @exec_str =
> > > 'C:\Progra~1\Micros~1\MSSQL\Binn\textcopy.exe /S ' + @srvname
> > > +
> > > ' /U ' + @login +
> > > ' /P ' + @password +
> > > ' /D ' + @dbname +
> > > ' /T ' + @tbname +
> > > ' /C ' + @colname +
> > > ' /W "' + @whereclause +
> > > '" /F ' + @filename +
> > > ' /' + @direction
> > > EXEC master..xp_cmdshell @exec_str
> > > GO
>
> > > I believe that I must be having some sort of right issue on the
> > > Production server where I am now trying to run this. It works
> > > perfectly in Development.
>
> > No, it's not a permissions issue. But it would be as simple that on
> > the production box, SQL Server is not installed on the C disk. Or
> > that the 8.3 name for C:\Program Files\Microsoft SQL Server is
> > different. The first thing to try is replace the 8.3 parts with the
> > long names. Next is to check where textcopy is located on the
> > production server.
>
> > --
> > Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> > Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> > Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx-Hide quoted text -
>
> > - Show quoted text -
>
> Did all of that already, checked the location of the textcopy.exe and
> it does exist in the same location on dev as it does on production. I
> tried using the long names and the short name both, still same
> results... I have basically gone through and verified everything and
> compared production to development, I am just frustrated right
> now....Thanks for all the ideas and help though I am open for all and
> any suggestions....- Hide quoted text -
>
> - Show quoted text -

Well I got past that error, I took the textcopy.exe file and put it in
the root of C:\ and changed the stored proc to reflect that change,
and now it runs with no issues....It just seems that it cannot find it
under the sql server installation location for some reason.....I
double checked the path several times??? Go figure.. Thanks for the
help though your suggestions about the path led me to try this out :)

[Back to original message]