I had a similiar error once. That problem was that the single user option
had gotten
checked.
That is under properties the access can be set to DBO use only - Single
user - Read only
Jeff Craig
----- Original Message -----
From: "Al Musella, DPM" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 10:11 AM
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]
>
------------------------------------------------------------------------------------------------
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]
