My initial thought is that sp_ is used to show system stored procedures... So perhaps SQL Server does not like that naming convention, try chagneing the name of the table...
Second thought is if C_Date is a datetime field in SQLServer you will want to wrap the date with a CreateODBCDate HTH -----Original Message----- From: michael firth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 2, 2002 17:13 To: CF-Talk Subject: OLEDB Error Code = 3621 Hey gang, Need help with a sqlserver error when running with coldfusion. The datasource, the query structure are fine. Also I am able to read data from the sqlserver database, but when I try to execute a insert statement I get the following error: OLEDB Error Code = 3621 The statement has been terminated. SQL = "Insert into Sp_Signup(Email,C_Date) Values('[EMAIL PROTECTED]','12/02/02')" Data Source = "MFXSP" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (35:1) to (35:42) in the template file c:\inetpub\wwwroot\superpetros\SIGNUP.CFM I have already tryed stopping and starting cfserver and the sqlserver but that doesnt seem to help. The coldfusion server is on its own machine and sql is on another, yet the datasource is working. Also when I created a new table in sql server, it also wouldn't read from that new table saying it was an invalid object. By the way the coldfusion is ver 5.0 and sql is ver 7.0. Thanks, Michael Firth --------------------------------- Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
