2147217900 error message 
Author Message
 2147217900 error message

I am using a program called a/egis, a sybase database. When I try to
paste notes into the ``notes`` from an .asp web page from which I
copied (using (cntrl-c) onto the clipboard  I get the following error
when I try to paste it(using cntrl-v)into A/egis.

-2147217900 : [microsoft][odbc sql server driver][sql server]Incorrect
syntax near 'S'.
[microsoft ole db provider for odbc drivers]
-2147217900 : [microsoft][odbc sql server driver][sql server]Unclosed
quote before the character string ',getdate[]]'.
[microsoft ole db provider for odbc drivers]

INSERT INTO TNOTE [CLM_OFFICE_CD,NOTE_KEY1,NOTE_KEY2
NOTE_TYPE_CD,NOTE_CREATE_DTTM,NOTE_TEXT,NOTE_SEQ_NO,USERID_CD,SOURCE_SYSTEM_ID,TIMESTAMP]VALUES['999001','001209253','B','02','2001-10-19
17:37:06','EMS TO BE PRESENTED TO THE WARRANTY COMPANY. TAKE A PHOTO
VERIFYING SHOP'S LABR RATE. VERIFY THE FRONT DRIVE SHAFT US SEUZED AT
FRT JOINT AND IS CAUSING A FRT END NOISE. VERIFY ANY RUST/CORROSION ON
UNDERCARRIAGE OF VEHICLE. VERIFY ALL FAILURES WITH PICTUR',
4,'ddriesse', 'AE',getdate[]]

Any ideas on where the problem is?

Thanks in advance, Dave



Wed, 07 Apr 2004 14:00:20 GMT  
 2147217900 error message
Not being near a SQL Server I can try it BUT,
In the body of the text you have ...VERIFYING SHOP'S LABR ...
That apostrophe in the word shop might not be helping !!
Try it again without.


Quote:
> I am using a program called a/egis, a sybase database. When I try to
> paste notes into the ``notes`` from an .asp web page from which I
> copied (using (cntrl-c) onto the clipboard  I get the following error
> when I try to paste it(using cntrl-v)into A/egis.

> -2147217900 : [microsoft][odbc sql server driver][sql server]Incorrect
> syntax near 'S'.
> [microsoft ole db provider for odbc drivers]
> -2147217900 : [microsoft][odbc sql server driver][sql server]Unclosed
> quote before the character string ',getdate[]]'.
> [microsoft ole db provider for odbc drivers]

> INSERT INTO TNOTE [CLM_OFFICE_CD,NOTE_KEY1,NOTE_KEY2

NOTE_TYPE_CD,NOTE_CREATE_DTTM,NOTE_TEXT,NOTE_SEQ_NO,USERID_CD,SOURCE_SYSTEM_
ID,TIMESTAMP]VALUES['999001','001209253','B','02','2001-10-19
Quote:
> 17:37:06','EMS TO BE PRESENTED TO THE WARRANTY COMPANY. TAKE A PHOTO
> VERIFYING SHOP'S LABR RATE. VERIFY THE FRONT DRIVE SHAFT US SEUZED AT
> FRT JOINT AND IS CAUSING A FRT END NOISE. VERIFY ANY RUST/CORROSION ON
> UNDERCARRIAGE OF VEHICLE. VERIFY ALL FAILURES WITH PICTUR',
> 4,'ddriesse', 'AE',getdate[]]

> Any ideas on where the problem is?

> Thanks in advance, Dave



Wed, 07 Apr 2004 14:56:48 GMT  
 2147217900 error message
Yeah, it's definitely the apostrophe that's doing. If you double it up
(SHOP''S), you should be OK.


Fri, 09 Apr 2004 22:01:04 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Error-2147217900, Syntax error in FROM clause

2. error -2147217900 instead of error -2147217873 from SQLserver

3. -2147217900 Error: Syntax error in INSERT INTO statement

4. runtime error -2147217900

5. Runtime Error 2147217900 ODBC with Access

6. SQL Syntax error in ORDER BY clause.(-2147217900)

7. Run-time error -2147217900

8. Error -2147217900

9. Error -2147217900

10. runtime error -2147217900

11. ADO Error -2147217900 (800040e14)

12. -2147217900 error

 

 
Powered by phpBB® Forum Software