DB-Library Error 10007: General SQL Server error: Check messages from the SQL

DB-Library Error 10007: General SQL Server error: Check messages from the SQL
      Server.                                                                




CREATE PROCEDURE [dbo].[spu_Import_Export_Image]
(
@srvr             varchar(50),
@db             varchar(50),
@usr             varchar(15),
@pwd             varchar(50),
@tbl             varchar(50),
@col             varchar(50),
@mod             varchar(1),
@imgpath1      varchar(1000),
@pk             varchar(50)
)

AS

BEGIN

declare @path            varchar(50)
declare @whr             varchar(200)
declare @fil             varchar(100)
declare @cmd            varchar(1000)
declare @imgpath       varchar(800)
declare @ext             varchar(5)
--declare @pk             varchar(50)
declare @KeyValue       varchar(8000)
declare @image       varchar(50)
--declare @imgpath1      varchar(1000)
declare @imgpath2      varchar(1000)
declare @sellist             varchar(2000)

set @path      = 'c:\textCopy.exe'


select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM  ' + @tbl + '  ORDER BY ' + @pk

exec (@sellist)

OPEN curKey
FETCH NEXT FROM curKey INTO @KeyValue

WHILE (@@fetch_status = 0)
  BEGIN
      set @whr      = '"where '+ @pk +' = "' + @KeyValue
      set @fil      = @imgpath1 + '\' + @KeyValue --+ @ext
      set @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr +  ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' +  @col + ' /W ' + @whr +  ' /F ' + @fil+ ' /' + @mod
      exec Master..xp_cmdShell @cmd
      FETCH NEXT FROM curKey INTO @KeyValue
  END


CLOSE curKey
DEALLOCATE curKey

END

GO


Above srcipt runs fine with image data type in one table but when i run for some other table it gives me Error Message


TEXTCOPY Version 1.0                                                          
 DB-Library version 8.00.194                                                  
 SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'. (Concern
      ing line 1)                                                            
 DB-Library Error 10007: General SQL Server error: Check messages from the SQL
      Server.                                                                
 ERROR: Could not use database 'test1'                                      
                                   
 NULL                                                                          
-----------

Aslo it only runs on server console if i run it from workstation uing same files and tables it gives me an error again. Can anybody help me and reply me at dharmesh@freewavetech.dom asap.

thnx,

dharmesh
                                                                            
                                                                            
                                          
DharmeshgandhiAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.