Are you sure that CF's ODBC setup has the exact same permissions as you used in registering your server in SQL enterprise manager?
Mark -----Original Message----- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 7:05 AM To: CF-Talk Subject: Error inserting into SQL 7.0 server Below is the text output of what i am trying to insert into a table in a sql 7.0 server. I have pasted the text into sql window of sql enterprise manager and it checked ok. But still gives me an odbc error. Any suggestions? INSERT INTO tbl_upload_content (UploadFilename,HyperLinkTitle,Description) Values ('CF_Print_zip','This is a test','Test of hyperlink and doc') <H4>Error Diagnostic Information</H4> <P>ODBC Error Code = 37000 (Syntax error or access violation) <P> <P>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near 'CF_Print_zip'. <P> <P> <P>The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (63:1) to (63:47).</P> <P> <P>Date/Time: 01/17/02 10:01:44<BR>Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)<BR>Remote Address: 127.0.0.1<BR>HTTP Referer: http://localhost/autoupload/upload.cfm</P> _________________________ _________________________ ____________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists