Ask a Question related to Coldfusion Database Access, Design and Development.
-
lacer8 #1
Re: unlocking Access databases in CFMX
I can't believe with as often as this is a problem for me, that it doesn't
appear more often in the forum. I search for a solution. I get the same answer,
but not not many instances of it... Run an invalid query. Well, I am running
one. But it doesn't break the lock. Does anyone see what I am doing wrong?
<cfif isDefined ('url.ds') AND url.ds NEQ "">
<cfquery name="breaker" datasource="#url.ds#" dbtype="odbc">
SELECT cool FROM killer Where access = 'Release'
</cfquery>
</cfif>
<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<p>This tool is intended to break the database lock. Expect an error. </p>
<form name="form1">Choose the database connection to break
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<option value="" selected>choose</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=threads">threads</option>
<option value="<cfoutput>#CurrentPage#</cfoutput>?ds=tb">tb</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=grownUpsMB">grownUpsMB</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=FCtopics">FCtopics</option>
<option value="<cfoutput>#CurrentPage#</cfoutput>?ds=fcQA">fcQA</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=lifeSkills">lifeSkills</option>
<option value="<cfoutput>#CurrentPage#</cfoutput>?ds=yabdb">yabdb</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=floatingHope">floatingHope</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=fcLibrary">fcLibrary</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=downloads">downloads</option>
<option value="<cfoutput>#CurrentPage#</cfoutput>?ds=fcApp">fcApp</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=fcAwards">fcAwards</option>
<option value="<cfoutput>#CurrentPage#</cfoutput>?ds=yabs">yabs</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=fcSpeakers">fcSpeakers</option>
<option value="<cfoutput>#CurrentPage#</cfoutput>?ds=evcal">evcal</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=allStars">allStars</option>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=LifeSkillsLand">LifeSkillsLand</opt
ion>
<option
value="<cfoutput>#CurrentPage#</cfoutput>?ds=ncData">ncData</option>
<option>unnamed2</option>
</select>
</form>
</body>
</html>
lacer8 Guest
-
unlocking Access databases in CFMX
ColdFusion pools connections. There are timeout settings on the connections. You have to have ZERO ACTIVITY on the connection pool before it lets... -
unlocking Access databases in CFMX
I have the same issue. I cannot unlock the .mdb file on my shared server. It uses CF7 and I was told and proven to myseld that "Maintain... -
Cannot access databases
When running an ASP.NET, it's not your administrative rights that are considered, but the rights granted to the ASPNET worker process that count.... -
Accessing 2 Access databases on 2 different servers using ASP pages
I have a Access database residing on our 'out-of- house, .com,shared' server. I have an asp page on the .com website that writes to this db,... -
PHP and Access databases
joanne.hall@btinternet.com idiotically stated: goto www.devshed.com and read their php/mysql tutorials. they basically walk you through... -
paross1 #2 Re: unlocking Access databases in CFMX
You didn't mention if Maintain Connections is selected in the advanced settings of your Access ODBC socket datasource -- it should NOT be.
Phil
paross1 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
