Have you tried running the query in Query Analyzer? Does it run there? Mike
-----Original Message----- From: David Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 10:42 AM To: CF-Talk Subject: Re: Error inserting into SQL 7.0 server I am using SA on the cf dsn. ----- Original Message ----- From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 12:29 PM Subject: RE: Error inserting into SQL 7.0 server > 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/[email protected]/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ______________________________________________________________________ Get Your Own 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=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
