--openmail-part-352daad2-00000001
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
;Creation-Date="Thu, 16 Nov 2000 11:41:44 -0600"
Content-Transfer-Encoding: 8bit
re: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'thethin'
is
already open and can only |
have one user at a time. |
Do you have any of the tables in "Design View" I havent checked how
this affects SQL server but I know with Access this can sometimes be the
case.
Misty
-----Original Message-----
From: musella [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 10:12 AM
To: cf-talk
Cc: musella
Subject: SQL Server error
I am getting 2 strange errors..
============================================
ODBC Error Code = 37000 (Syntax error or access violation) |
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'thethin' is
already open and can only |
have one user at a time. |
============================================
ODBC Error Code = S1T00 (Timeout expired)
[Microsoft][ODBC SQL Server Driver]Timeout expired
The error occurred while processing an element with a general identifier
of
(CFQUERY), occupying document position (69:1) to (69:89) in the template
file D:\THETHIN\FAQS.CFM.
=====================================================================
the query is simple:
<cfquery name="list" datasource="#SQLds#" username="#sqluser#"
password="#sqlpassword#">
select id,submitted,q,score from faq
where (approved = 1)
<cfif category is not '-1'>
and
<cfif findnocase('1', category)>category like '%1%'<cfset
more=1></cfif>
<cfif findnocase('2', category)><cfif more is 1> or <cfelse><cfset
more=1></cfif>category like '%2%'</cfif>
<cfif findnocase('3', category)><cfif more is 1> or <cfelse><cfset
more=1></cfif>category like '%3%'</cfif>
<cfif findnocase('4', category)><cfif more is 1> or <cfelse><cfset
more=1></cfif>category like '%4%'</cfif>
<cfif findnocase('5', category)><cfif more is 1> or <cfelse><cfset
more=1></cfif>category like '%5%'</cfif>
<cfif findnocase('6', category)><cfif more is 1> or <cfelse><cfset
more=1></cfif>category like '%6%'</cfif>
</cfif>
<cfif sortby is 'score'>
order by score desc,submitted desc
<cfelse>
order by submitted desc,score desc
</cfif>
</cfquery>
=======================
This is SQL server 7, Cold fusion 4.5.1 - on separate boxes..
There has been no change to the cold fusion templates on this website in
about 6 months. These errors started popping up very infrequently a few
weeks ago.. Maybe once every few days. When the first error happens, I
have to reboot the cold fusion server and it works again. The second one
clears itself quickly and works again.
The only change I see is a increase in the database size, as well
as
an increase in the number of visitors to the site.
When this happens, other databases still work.
That query takes only about 200ms. How could it time out? Any ideas?
I do not have any other programs opening it - the servers are
co-located,
and do not even have MS access installed.
I do use MTS packages to copy the database to my home computer a few
times
a day.. would that exclusively lock the table and cause problems?
Thanks
Al Musella, DPM
A1webs.com
------------------------------------------------------------------------
------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
--openmail-part-352daad2-00000001--
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
