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
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
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
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
>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 Enterprise Manager? My guess is that the problem
is with the date value. What
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
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
--
sp_ might be invalid for a table name? SP_ is for system procedure IIRC and
SQL may not like it being used as a table name. Try to change the table's name
and see if that does anything.
Can you run the statement in query analyzer manually? At least possibly narrow
down the point of failure.
On Mo
"sp" normally means "stored procedure". Are you trying to insert into a
stored proc?
Rob
http://treebeard.sourceforge.net
http://ruinworld.sourceforge.net
Scientia Est Potentia
-Original Message-
From: michael firth [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:13 AM
To: C
9 matches
Mail list logo