RE: OLEDB Error Code = 3621

2002-12-02 Thread Rob Rohan
ilto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:29 AM To: CF-Talk Subject: Re: OLEDB Error Code = 3621 I tryed renaming the table and that didnt seem to work. Plus also the C_Date is a nvarchar field, but what I tryed to do was run the query without the field and still got the oledb error

problem fixed! RE: OLEDB Error Code = 3621

2002-12-02 Thread michael firth
Hey gang, Thanks for the assist espically the info on stored procedures, but really wasn't using any. It turns out that in the administrator, in settings, the compress whitespace box was checked and soon as i turn it off it started working. So it wasnt a sql but a coldfusion thing. Thanks, M

RE: OLEDB Error Code = 3621

2002-12-02 Thread Mike Townend
To you yes... Not necessarily to SQL Server... If you rename the table does the problem still occur.. HTH -Original Message- From: michael firth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 2, 2002 17:21 To: CF-Talk Subject: RE: OLEDB Error Code = 3621 Nah its not a stored

Re: OLEDB Error Code = 3621

2002-12-02 Thread michael firth
I tryed renaming the table and that didnt seem to work. Plus also the C_Date is a nvarchar field, but what I tryed to do was run the query without the field and still got the oledb error code. Also I did run the query in query analyzer and it worked just fine. Second, I tryed changing the dat

Re: OLEDB Error Code = 3621

2002-12-02 Thread Scott Brady
>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" > Have you tried running that query in Enterpris

RE: OLEDB Error Code = 3621

2002-12-02 Thread michael firth
Nah its not a stored procedure, just a short abbreviation for super petros. Mike - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now ~| Archives: http://www.houseoffusion.com/cf

RE: OLEDB Error Code = 3621

2002-12-02 Thread Mike Townend
-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

Re: OLEDB Error Code = 3621

2002-12-02 Thread John Wilker
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')" > Da

RE: OLEDB Error Code = 3621

2002-12-02 Thread Rob Rohan
02, 2002 9:13 AM 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 fol

OLEDB Error Code = 3621

2002-12-02 Thread michael firth
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

OLEDB Error Code = 3621 The statement has been terminated.

2002-05-23 Thread Hoag, Claudia (LNG)
"OLEDB Error Code = 3621 The statement has been terminated." The query looks fine and runs without error in Query Analyzer. We have CF4.5, MSSQL 2000, latest MDAC. Does anyone have some insight on this? Thank