What is the best way to gracefully trap this sort of error ...
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
The error occurred on line 3.
TNX for any suggestions.
Rick.
Have you tried cftry/cfcatch?
--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/
On 8 November 2010 23:07, Rick Colman rcol...@cox.net wrote:
What is the best way to gracefully trap this sort of error ...
Error Executing Database Query. [Macromedia][SequeLink JDBC
The best way would be to validate the data before getting your database
involved.
On Mon, Nov 8, 2010 at 10:07 AM, Rick Colman rcol...@cox.net wrote:
What is the best way to gracefully trap this sort of error ...
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
A good site-wide error handler that sends alert e-mails would help.
The cferror tag is one method that works well.
-Mike Chabot
On Mon, Nov 8, 2010 at 10:07 AM, Rick Colman rcol...@cox.net wrote:
What is the best way to gracefully trap this sort of error ...
Error Executing Database Query.
This was a really good idea, and solved the problem. I validated for an
integer, and the error went away. TNX.
On 11/8/2010 7:49 AM, Michael Grant wrote:
The best way would be to validate the data before getting your database
involved.
On Mon, Nov 8, 2010 at 10:07 AM, Rick
, February 17, 2010 6:12 PM
To: cf-talk
Subject: local sql error, not on live site.
I have a local install of sql server developer edition 2005. I have used
the data base publishing wizard to copy the db from crystaltech to my local
server.
I am getting an error in a query that does not happen
On 2/18/10, Matthew Smith wrote:
I am getting an error in a query that does not happen with crystaltech.
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server
Driver]Invalid precision value
I am betting that a reputable hoster such as
That did it.
Set up a regular sql server datasource and it worked.
Thank you so much.
Just out of curiosity, when should I use nvarchar as opposed to varchar?
On Thu, Feb 18, 2010 at 12:20 PM, Jochem van Dieten joch...@gmail.comwrote:
On 2/18/10, Matthew Smith wrote:
I am getting an
Just out of curiosity, when should I use nvarchar as opposed to varchar?
nvarchar allows for an expanded set of characters, for example if you want
your app to be able to handle double byte characters for non latin languages
such as Chinese or Russian you would use nvarchar or ntext.
However,
I also believe (though I'm happy to be corrected if I'm wrong) that
you can later safely switch from a varchar to an nvarchar. You'd be in
danger of truncating data if you went from nvarchar to varchar, but
since varchar is a subset of nvarchar, changing the data type at a
later date should be
I have a local install of sql server developer edition 2005. I have used the
data base publishing wizard to copy the db from crystaltech to my local server.
I am getting an error in a query that does not happen with crystaltech.
Error Executing Database Query.
[Macromedia][SequeLink JDBC
I'm using Oracle and CF7, doing a Query of Query. I'm attempting to research a
query to find any that the title doesn't have affiliate Faculty in it.
The query of query is giving me an error:
The system has attempted to use an undefined value, which usually indicates a
programming error,
This is related to an earlier post today Coldfusion 8 Data Source Timeout.
I am still getting a timeout when configuring a certain Data Source to a remote
database.
Using dbaccess from my CF8 machine works - no problem.
I looked the cfserver.log and get: A non-SQL error occurred while
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 28: Incorrect syntax
near '@P10'.
I haven't the foggiest idea what's going on here.
here's the passed in params from the java trace:
(param 1) = [type='IN', class='java.lang.String', value='Elmer',
sqltype='cf_sql_varchar'] ,
(param 2) =
Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
WWW: http://www.evoch.com/
-Original Message-
From: Scott Stewart [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2008 4:04 PM
To: CF-Talk
Subject: Break from the SQL Injection thread weird SQL error
[Macromedia
-Original Message-
From: Doug Brown [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: 11/14/06 7:17 PM
Subject: Sql error during insert
I do not recall seeing this before. Could someone tell me what I am doing
wrong? I get the following error while executing this query
I do not recall seeing this before. Could someone tell me what I am doing
wrong? I get the following error while executing this query.
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax
near '@P1'.
cfset mylist=Antiques
Art
If this is a true copy and paste, you're missing your ending ')' in the
VALUES statement.
On 11/14/06, Doug Brown [EMAIL PROTECTED] wrote:
I do not recall seeing this before. Could someone tell me what I am doing
wrong? I get the following error while executing this query.
Error
You are missing a ) after the queryparam
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 10:15 PM
To: CF-Talk
Subject: Sql error during insert
I do not recall seeing
You also need to specify the delimiter in your loop as a |
..:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Crow T. Robot [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 10:22 PM
To: CF-Talk
Subject: Re: Sql error during insert
Never mind...I missed a closing ) on my query. Geez looked at it forever.
D.B
- Original Message -
From: Doug Brown [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, November 14, 2006 8:15 PM
Subject: Sql error during insert
I do not recall seeing this before
Thanks. I hate it when the little stuff haunts you -)
Doug
- Original Message -
From: Bobby Hartsfield [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, November 14, 2006 8:21 PM
Subject: RE: Sql error during insert
You are missing a ) after the queryparam
Hi everyone first post and unfortunately it had to be OT... Here's the
scoop...
Real new to SQL, currently reading through CF7 Web application
construction kit and the install script for the MySQL data for this book
is throwing me this error:
You have an error (1064) in your SQL syntax; check
Anyone ever seen this?
Error Occurred While Processing Request
7 = 7
the query is a simple select query...
SELECT * FROM GALLERY_PHOTOS
where
blog_id=cfqueryparam cfsqltype=CF_SQL_INTEGER value=#blog_id#
and gallery_id=cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#GALLERY_ID#
(I don't know
Rick Root wrote:
Anyone ever seen this?
Error Occurred While Processing Request
7 = 7
the query is a simple select query...
SELECT * FROM GALLERY_PHOTOS
where
blog_id=cfqueryparam cfsqltype=CF_SQL_INTEGER value=#blog_id#
and gallery_id=cfqueryparam cfsqltype=CF_SQL_INTEGER
Does anyone know why this would occur?
Error Executing Database Query. [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Invalid
precision value
I am using MS-Access and using CFQUERYPARAM tags. The tags are specified
properly such
as Integer or
I'm not too hot with Access but if that were SQL Server my first thought
would be to look at decimal datatypes.
Ade
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: 01 April 2005 23:27
To: CF-Talk
Subject: SQL Error
Does anyone know why this would occur
But there is no decimals in this.
Adrian Lynch wrote:
I'm not too hot with Access but if that were SQL Server my first thought
would be to look at decimal datatypes.
Ade
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: 01 April 2005 23:27
To: CF-Talk
Subject: SQL
-
From: ColdFusion Developer [mailto:[EMAIL PROTECTED]
Sent: 02 April 2005 00:50
To: CF-Talk
Subject: Re: SQL Error
But there is no decimals in this.
Adrian Lynch wrote:
I'm not too hot with Access but if that were SQL Server my first thought
would be to look at decimal datatypes.
Ade
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: April 1, 2005 2:27 PM
To: CF-Talk
Subject: SQL Error
Does anyone know why this would occur?
Error Executing Database Query. [Macromedia][SequeLink JDBC
Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver
1, 2005 4:31 PM
To: CF-Talk
Subject: RE: SQL Error
I recently had this same issue with a site that was switched from CF5 to
MX61. Client storage DB was choking on the CFDATA table's data field which
is also a memo field. Solved it by creating a new data source in CFadmin
using the Access driver
after an insert... the inserted record can not be found... it's there,
I can see it but this query returns with zero records found.
The Details:
First:
INSERT INTO DocsList
(DocsList_ID,filename)
VALUES (746,'H:\UpLoadImages\CmosPic.jpg')
then sometime later we Check4Duplicate with:
after an insert... the inserted record can not be found...
it's there, I can see it but this query returns with zero
records found.
The Details:
First:
INSERT INTO DocsList
(DocsList_ID,filename)
VALUES (746,'H:\UpLoadImages\CmosPic.jpg')
then sometime later we Check4Duplicate
Try using the CFQUERYPARAM tag
__
Pete Freitag
http://www.cfdev.com/
Author of the CFMX Developers Cookbook
http://www.petefreitag.com/bookshelf/
~|
Special thanks to the CF Community Suite
Yep '\ is reserved in Postgres, and CF doesn't escape it like it
auto-escapes apostrophe.
I think \\ is the escape for it, so turning
'H:\UpLoadImages\CmosPic.jpg' into 'H:\\UpLoadImages\\CmosPic.jpg' may
work. Also, cfqueryparam may clear it up completely.
Someone here is bound to know
YES ! Thank you... was using it for the INSERT but not for the
SELECT... rumor has it that it should be used for EVERYTHING... but
alas I find it hard to buckle down and upgrade all the queries.
Thanks Pete,
Very Much Appreciated!
Gonz
On Fri, 19 Nov 2004 16:12:55 -0500, Pete Freitag [EMAIL
Why would I get this SQL error : Error converting data type varchar to numeric on one filed and not another when I do a submit from a form even though they are setup the same. Both are numeric in the SQL table.
I'm entering them this way:
CFIF getponumber.recordcount EQ 0 OR VAL
This parameter value:(param 15) = [type='IN', class='java.lang.Double',
value='44.5', sqltype='CF_SQL_MONEY']
is creating the following error:Error Executing Database Query. Invalid data
for CFSQLTYPE CF_SQL_DOUBLE.
This is storing a value to a MS Access DB field that has data type of
currency.
Hi,
Have an interesting problem. I'm using Encrypt() to store sensitive user
data in SQL Server. On some strings, the function is encrypting with a
single quote as one of the chars. This is causing a SQL error when I'm
trying to either enter or retrieve the data with cfquery.
Has anyone run
in string, causes SQL error when
trying to SELECT
Hi,
Have an interesting problem. I'm using Encrypt() to store sensitive user
data in SQL Server. On some strings, the function is encrypting with a
single quote as one of the chars. This is causing a SQL error when I'm
trying to either enter or retrieve
://www.euservices.com
__
-Original Message-
From: Creese, Eric [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 1:17 PM
To: CF-Talk
Subject: Unusual SQL error
I never have received this error before.
[Macromedia][SQLServer
Thanks,
I added the option (maxdop 1) to the end of the query to set the max degree of
parallism to 1
-Original Message-
From: Bill Grover [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 9:30 AM
To: CF-Talk
Subject: RE: Unusual SQL error
Sounds to me like when SQL created it's
-1299WWW:http://www.euservices.com
__
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 10:34 AM
To: CF-Talk
Subject: RE: Unusual SQL error
Thanks,
I added the option (maxdop
: Monday, July 07, 2003 10:36 AM
To: CF-Talk
Subject: RE: Unusual SQL error
That should fix it.
__
Bill Grover
Supervisor MIS Phone: 301.424.3300 x3324
EU Services, Inc. FAX:301.424.3696
649 North
:http://www.euservices.com
__
-Original Message-
From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 10:47 AM
To: CF-Talk
Subject: RE: Unusual SQL error
Bill,
This just got me thinking
I never have received this error before.
[Macromedia][SQLServer JDBC Driver][SQLServer]Intra-query parallelism caused
your server command (process ID #52) to deadlock. Rerun the query without
intra-query parallelism by using the query hint option (maxdop 1).
Can anyone give some insite?
OK, I cannot see where this SYNTAX error is can anyone else see the possible problem?
Below are two queries, both are the same, one is PRE-CF (variables) one is POST CF
after CF processes the variables that makes it a query.
(WHERE weight = apos;30apos;) Is just what is outputted in the
If the weight field is number then it should be weight = 30 and not
weight = '30'
[EMAIL PROTECTED] 03/10/03 09:58AM
OK, I cannot see where this SYNTAX error is can anyone else see the
possible problem? Below are two queries, both are the same, one is
PRE-CF (variables) one is POST CF after
the table
name in brackets such as [2da] and see if that works.
-Justin Scott
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 10, 2003 9:58 AM
Subject: OT: SQL Error with Syntax
OK, I cannot see where this SYNTAX error is can
Quoting integers in SQL Server is valid, and can help protect against some
hack attempts.
-Justin Scott
- Original Message -
From: Randell B Adkins [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, March 10, 2003 10:00 AM
Subject: Re: OT: SQL Error with Syntax
I think I must be the king of strange errors and events, but I do have
another one to ask about.
Today, all of our applications on one server which all have been
performing for over a year with client variables in a SQL database
started showing up with the following error.
An error occurred
I am getting a very non-descript error in CFMX when doing a query on
query. Has anybody seen this error before? I have posted the CFMX/SQL
code below as well.
Thanks
- Error Message -
Error casting an object of type java.lang.boolean to an incompatible
type. This usually indicates a
access db to SQL and all the values in an access
'number' field were integers, the upsizer would probably create a SQL field
with type 'int'.
HTH
Alex
-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 03:30
To: CF-Talk
Subject: SQL error - Arithmetic
This ran just fine using Microsoft Access. Now I get an overflow?
Can you spot what's wrong? The values in the fields aren't very big - the
largest is like 1952 to which I'm adding 20 or 30 or so...
=
ODBC Error Code = 22003 (Numeric value out of range)
[Microsoft][ODBC SQL Server
I have a action page that accepts any form page and its variables then based on the
stored proc sp_columns builds sql statment for update or insert.
When I try to use it I get an Datefield overflow error (SQL 2000). But if I output
the sql statment and then copy and past it into my sql
-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 11:26 AM
To: CF-Talk
Subject: strange SQL error
I have a action page that accepts any form page and its variables then based
on the stored proc sp_columns builds sql statment for update or insert.
When I try to use it I
In all my time developing SQL I have never come across sommat like this -
please someone tell me I'm being stoopid as it's a Fri
afternoon.
I have the following SP which refuses to release - it says it cannot find
parameter JuryTitle. If I comment out JuryTitle and the corresponding
ColdFusion is
requesting a lock at table level somewhere. Is there a CFAdmin setting for
this?
-Original Message- From: Houk, Gary
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 3:06
PM To: CF-Talk Subject: What is this SQL Error? First time I've seen this
one...what does it mean
, @JuryName
, @JuryTitle
, @JuryCompany
, @JuryCity
, @JuryTypeID
?
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 16:56
To: CF-Talk
Subject: Strange SQL error
In all my time developing
ah - yes sorry - forgot to change it back
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 16:50
To: CF-Talk
Subject: RE: Strange SQL error
I assume in this bit:
VALUES (
@CountryID
, @JuryName
, @test
If you're getting a deadlock error, chances are that it has to do with the
order that your queries are going. If you have one page with a transaction
that starts with an insert to Table A and then updates all the rows in Table
B while you have another page with a transaction that inserts into
I'm trying to figure out if ColdFusion locks the whole table
when running a cfquery.
This is entirely dependent on the database. CF is just a regular database
client, like any other database client.
I'm getting those deadlock errors in production, where too
many people access the same
Right fixed it - all we did was to move the declaration of the JuryTitle
param to the bottom of the list and itr works! SQL schmeequel
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 16:50
To: CF-Talk
Subject: RE: Strange SQL error
I assume in this bit
uh?
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 17:18
To: CF-Talk
Subject: RE: Strange SQL error
Right fixed it - all we did was to move the declaration of
the JuryTitle
param to the bottom of the list and itr works! SQL schmeequel
-Talk
Subject: RE: Strange SQL error
uh?
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 17:18
To: CF-Talk
Subject: RE: Strange SQL error
Right fixed it - all we did was to move the declaration of
the JuryTitle
param to the bottom of the list
-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:19 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: What is this SQL Error?
I'm trying to figure out if ColdFusion locks the whole table
when running a cfquery.
This is entirely dependent
code through notepad if I've touched anything like Word or
Wordpad
for example because of the illegal characters.
Margaret
-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 9:25 AM
To: CF-Talk
Subject: RE: Strange SQL error
What Andy meant
]]
Sent: Friday, May 17, 2002 12:27 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
Thanks, I'll discuss that with our DBA.
I'm not using any CFTRANSACTION, though. What might have an impact here is
that this is a code that loops up to four times and does an insert every
time. The user selects
I'm not using any CFTRANSACTION, though. What might have
an impact here is that this is a code that loops up to four
times and does an insert every time. The user selects up
to four items, and then the code loops through them and
inserts a record in the table in each iteration.
Well,
PROTECTED]]
Sent: Friday, May 17, 2002 12:27 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
Thanks, I'll discuss that with our DBA.
I'm not using any CFTRANSACTION, though. What might have an impact here is
that this is a code that loops up to four times and does an insert every
time. The user
The DBA wants me to call a stored procedure, wait until the
stored procedure is done, then continue with the loop to call
it again... Is there a way to make sure the store procedure
is done before the code continues?
I'm pretty sure that CF will handle this for you; CF won't call the next
:) yes, I guess I can do that!
Thanks
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:40 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
I guess you could wait for a return code from the SP and test for it in your
code. Used to do
17, 2002 12:46 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: What is this SQL Error?
The DBA wants me to call a stored procedure, wait until the
stored procedure is done, then continue with the loop to call
it again... Is there a way to make sure the store procedure
Yes, but if it calls the database and doesn't wait for
anything back, just goes ahead and calls it again...
wouldn't it happen the same as when I call the queries
- and the loop is faster than the database?
It has to wait until the database server returns a message, before
continuing.
: Friday, May 17, 2002 12:50 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
Yes, but if it calls the database and doesn't wait for anything back, just
goes ahead and calls it again... wouldn't it happen the same as when I call
the queries - and the loop is faster than the database
I thought about using cftry/cfcatch, but what if my second
attempt is still done before the table is again available...
I was wondering if ColdFusion had a timer function - such
as, wait 300ms before continuing?
No, it doesn't, but I don't think that matters, since CF's processing of
, 2002 1:07 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: What is this SQL Error?
I thought about using cftry/cfcatch, but what if my second
attempt is still done before the table is again available...
I was wondering if ColdFusion had a timer function - such
as, wait 300ms
But isn't it what's happening with the hotspot problem? -
the query is done, but the database still has the page locked.
I seriously doubt that your problem is occurring because of one individual
instance of your page running. However, if you have more than one person
adding records at the
This one is driving me nuts. I keep getting a 'Base table not found error'.
Invalid object name 'Products'.
This is my query:
SELECT Industries.name as industryName, Products.name as
productName,
Products.version, Products.prefix, Products.ID as prodID
FROM
: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 16 May 2002 10:13 a.m.
To: CF-Talk
Subject: sql error
This one is driving me nuts. I keep getting a 'Base table not
found error'.
Invalid object name 'Products'.
This is my query:
SELECT Industries.name as industryName
-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Wed 5/15/2002 5:12 PM
To: CF-Talk
Cc:
Subject: sql error
__
Structure your ColdFusion code with Fusebox. Get
[EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: sql error
Date: Thu, 16 May 2002 10:18:41 +1200
Um, wild guess . . . no Products table? Are you referencing the wrong
database?
Regards,
Matthew Walker
/*
Cabbage Tree Creative Ltd
Christchurch - New
I think I figured it out. I have a web farm and the database name was not
specified on one of the server's CF Admin.
thx
From: S R [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: sql error
Date: Wed, 15 May 2002 15:24:56 -0700
That's why
PROTECTED]]
Sent: Wednesday, May 15, 2002 3:31 PM
To: CF-Talk
Subject: RE: sql error
I think I figured it out. I have a web farm and the database name was not
specified on one of the server's CF Admin.
thx
From: S R [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED
I think I figured it out. I have a web farm and the database
name was not specified on one of the server's CF Admin.
that's not it. That would give you a DATASOURCE NOT FOUND
error. Chances are you just mapped to the wrong DB somewhere
or your permissions are screwed up somehow.
No,
That's exactly what happened. The datasource was there but with no database
specified on one of the servers.
From: Dave Watts [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: sql error
Date: Wed, 15 May 2002 18:51:11 -0400
I think I figured it out. I
First time I've seen this one...what does it mean?
Diagnostics: ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID
60) was deadlocked on {lock} resources with another process and has been
chosen as the deadlock victim. Rerun the
]]
Sent: Tuesday, April 16, 2002 3:06 PM
To: CF-Talk
Subject: What is this SQL Error?
First time I've seen this one...what does it mean?
Diagnostics: ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID
60) was deadlocked on {lock
Thanks Bob...I'll let you know if I find a workaround.
- Gary
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:11 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
We've run into this from time to time, it occurs when two or more users
are you sure you are using transaction statements.
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Bob Imperial [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 4:11 PM
To: CF-Talk
Subject: RE: What is this SQL Error
After re-starting sql server2000 sp2, I have noticed the following error in
the CF log files. Its happening sporiacally for the users. Then if they hit
refresh once it happens, the page will execute successfully.
Can't find anything on Microsoft's site about it or in the actual sql server
I know this is suppose to be for CF stuff, but I know
someone can help with this. I'm under the gun here.
I'm getting this SQL 2000 error message when I try to
add a new column to an existing table that's filled with
data.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Could not
Your database is full. Allocate more space for it in Enterprise Manager.
Dan Phillips
CFXHosting.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 10:42 AM
To: CF-Talk
Subject: SQL Error, I know
I know this is suppose
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Could not allocate space for
object 'Tmp_samp_request' in database 'hititte4_db'
because the 'PRIMARY' filegroup is full.
is that db set to grow? if so, your disk is probably filled. if
not, allow it to grow...
To: CF-Talk
Subject: Re: SQL Error, I know
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Could not allocate space for
object 'Tmp_samp_request' in database 'hititte4_db'
because the 'PRIMARY' filegroup is full.
is that db set to grow? if so, your disk is probably filled
filegroup (SQL groups data/objects into filegroups). By any chance are you
running SQL on SBS (Small business Server)?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 15:48
To: CF-Talk
Subject: Re: SQL Error, I know
ODBC error: [Microsoft
If you are running SQL on SBS there is a maximum size to your filegroups
(which you can easily reach). It sucks believe me
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 16:02
To: CF-Talk
Subject: RE: SQL Error, I know
Not quite sure. Our
Is there any solution?
If you are running SQL on SBS there is a maximum size to your filegroups
(which you can easily reach). It sucks believe me
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 16:02
To: CF-Talk
Subject: RE: SQL Error, I
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 19, 2002 10:01 AM
Subject: RE: SQL Error, I know
Not quite sure. Our ISP is hosting our CF Web site
along with SQL 2000. The ISP's Adminsitrator is trying
to tell me it's a Professional
16:02
To: CF-Talk
Subject: RE: SQL Error, I know
Not quite sure. Our ISP is hosting our CF Web site
along with SQL 2000. The ISP's Adminsitrator is trying
to tell me it's a Professional Services request and
wants to charge me $200/hour to fix the problem.
D-
nice one - seen
1 - 100 of 147 matches
Mail list logo
