Solved

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

Posted on 2003-11-04
3
4,313 Views
Last Modified: 2007-12-19
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
                                                                            
                                                                            
                                          
0
Comment
Question by:Dharmeshgandhi
3 Comments
 
LVL 6

Accepted Solution

by:
lausz earned 20 total points
ID: 9678141
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now