No. I haven't even looked at those tables in 6 months:)
>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]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
https://secure.houseoffusion.com
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
