>> >Is the problem random or reproducible?
>> Random, but when it happens, it seems to stay that way for a while. A CF
>> service restart will correct it for a while.
>
>
>This behavior is consistent with a connection in the database connection
>pool switching ac
>
> >Is the problem random or reproducible?
> Random, but when it happens, it seems to stay that way for a while. A CF
> service restart will correct it for a while.
This behavior is consistent with a connection in the database connection
pool switching active databases. The
>Is the problem random or reproducible?
Random, but when it happens, it seems to stay that way for a while. A CF
service restart will correct it for a while.
>Is dbBanana used anywhere by the Web
>site, or should that database not be used at all?
It is used. Both are used by the site with the
Never happened to me. I think this setup is very common (having a
single SQLSERVER, and creating multiple DSNs to different databases),
someone would have run into it.
Try dumping SELECT @@SERVERNAME, DB_NAME() to see if you really are
connected to the correct DB
Do you have code that do USE
Is the problem random or reproducible? Is dbBanana used anywhere by the Web
site, or should that database not be used at all? If it should not be used
at all, do a site-wide search for dbBanana to make sure it does not show up
anywhere in the code. Are the two databases allowed to talk to each oth
Basics: Windows 2003 server, CF 7.0.2, SQL Server 8
Multiple datasources, but lets specifically look at the ones named Apple and
Banana. They point to separate databases on the same SQL server, connecting to
db Apple and db Banana respectively, as expected. However, occasionally,
datasource Ap
is the data source setup as a native sql driver or ODBC? I've run into speed
problems in the past when we had to use the ODBC instead of the native sql one.
also, if you go into the mgmt. studio and run the same query in the query tool
is the response immediate and much faster? If not, maybe che
Kevin, were you using ODBC socket connections, or ODBC connections? Or, which
driver exactly was it that you selected in the CF admin? I'm having the same
problems that you are, and I'm not sure that the upgrade of the JDBC drivers is
going to fix the problem. Thanks!
> Well I have just repl
Well I have just replaced the JDBC Drivers with the latest version 3.5. This
has reduced the time taken by a huge amount. There is no mention in the docs of
there being anything that would do that.
The same change on the test server made no difference.
Kevin
~~
On Wednesday 23 Jan 2008, Kevin Roche wrote:
> Anyone have any other ideas?
Broken or bad router, network etc. etc. ?
Does a (flood) ping indicate health there ?
--
Tom Chiverton
Helping to autoschediastically revolutionize compelling metrics
on: http://thefalken.livejournal.com
**
I have checked and the settings are exactly the same on live, and test servers.
Maintain connections across client requests. is checked
Enable Unicode for data sources configured for non-Latin characters. is
unchecked
All the other parameters under the advanced tab are the same. In fact they h
Thanks guys I will check both those suggestions.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.h
Kevin Roche wrote:
> The envionment is CF7.0.2 and SQL Server 2005.
>
> It appears that queries are taking longer than usual to complete. Even simple
> queries can take over a second to execute. The test server has no problem
> executing the same query in 100ms.
Is there a difference between bo
Be sure that connection pooling is checked on the datasource in
Coldfusion
-Original Message-
From: Kevin Roche [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 22, 2008 1:28 PM
To: CF-Talk
Subject: ColdFusion slow database connection to SQL2005
The envionment is CF7.0.2 and SQL Server
Run SQL Profiler from a remote computer and see if the queries are
taking long to execute on the database server. You want to isolate the
problem if possible, and knock out the ColdFusion server or the
network connection from the list of possible culprits. It isn't clear
from your message where the
The envionment is CF7.0.2 and SQL Server 2005.
It appears that queries are taking longer than usual to complete. Even simple
queries can take over a second to execute. The test server has no problem
executing the same query in 100ms.
I supect there is some configuration issue which means that t
Rob O'Brien wrote:
>> I tested shutting down my datasource, and it retured false in about 1-2
>> seconds in my local environment.
>
> This looks like exactly what I'm looking for and I really appreciate the
> effort.
>
> I tested the same way. I stop the SQL Server service and then refresh the
>
9, 2007 5:17 PM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
>I tested shutting down my datasource, and it retured false in about 1-2
>seconds in my local environment.
This looks like exactly what I'm looking for and I really appreciate the
effort.
I tested th
TED]
Sent: Friday, April 20, 2007 1:02 PM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
Rob,
This may sound simple, maybe too simple, but how long does your application
take to error on a cfquery if the table isn't available?
I useed a different approach, rather then
>I tested shutting down my datasource, and it retured false in about 1-2
>seconds in my local environment.
This looks like exactly what I'm looking for and I really appreciate the
effort.
I tested the same way. I stop the SQL Server service and then refresh the
script.
Unfortunately, this still
TED]
Sent: Thursday, April 19, 2007 12:07 PM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
> There is a decent chance that the admin api functionality gives you
> access to the same thing that happens when you click the "verify data
> source" icon in
> There is a decent chance that the admin api functionality gives you
> access to the same thing that happens when you click the "verify data
> source" icon in CF Admin.
Yes, you can get this from the adminapi:
// you must log in before accessing other adminapi components
admin
~Brad
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 11:52 AM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
Here is a stack trace of what CF is doing when it verifies a data source
from CF ADMIN.
Unfortunately these file
essage-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 11:43 AM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
Doesn't look promising anymore.
http://livedocs.adobe.com/coldfusion/7/htmldocs/1738.htm
That link tells you how to a
, April 19, 2007 11:30 AM
To: CF-Talk
Subject: RE: Testing Database Connection within Application
There is a decent chance that the admin api functionality gives you
access to the same thing that happens when you click the "verify data
source&qu
Out of curiosity, how are you testing it? Are you turning off your
database and then refreshing the page to see what happens?
~Brad
-Original Message-
From: Rob O'Brien [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 19, 2007 11:30 AM
To: CF-Talk
Subject: RE: Testing Dat
38 AM
To: CF-Talk
Subject: Testing Database Connection within Application
I've done my searching online, throughout several groups, and now I turn
to
you guys.
I've been having trouble figuring out how to detect, from within my
ColdFusion application, whether or
o: CF-Talk
Subject: RE: Testing Database Connection within Application
You could wrap your database call in a cftry block and then specify code to
run when an error happens.
code to run in event of database error (cfmail?)
-Original Message-
From: Rob O'Brien [mailto:[
-Talk
Subject: Testing Database Connection within Application
I've done my searching online, throughout several groups, and now I turn to
you guys.
I've been having trouble figuring out how to detect, from within my
ColdFusion application, whether or not my database connection is v
I've done my searching online, throughout several groups, and now I turn to
you guys.
I've been having trouble figuring out how to detect, from within my
ColdFusion application, whether or not my database connection is valid.
The DB setup is valid, but my goal is to automatica
Is it MS SQL 200 or MS SQL 2005?
If 2005, the tcp/ip port 1433 is not switched on by default.
On 3/9/07, Paul Dormody <[EMAIL PROTECTED]> wrote:
>
> I have looked at the Adobe help files and Forta's blog about setting up
> a MS SQL datasource in CF MX 7. I have followed all of the suggestions
>
I have looked at the Adobe help files and Forta's blog about setting up
a MS SQL datasource in CF MX 7. I have followed all of the suggestions
and still cannot get a connection.
I need help.
Thank you,
Paul Dormody
[EMAIL PROTECTED]
651-208-9600
~~
> Is there a database connection limitation of 3000 connections?
I have no idea, but I wouldn't be surprised if there was.
> If so what does this actually mean in terms of user usage?
Not much, for most people. If CF actually had three thousand open database
connections simultane
>From the Adobe nee Macromedia Forums.
Is there a database connection limitation of 3000 connections? If so what does
this actually mean in terms of user usage?
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Bin
have you tried connecting to htis Oracle DB via SQL+? first thing I
would try and do. also, tnsping it to make sure the listner is up and
alert.
DK
On 8/11/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> This morning we started experiencing a problem where whenever we tried to
> connect to a ce
This morning we started experiencing a problem where whenever we tried to
connect to a certain Oracle DSN, the CPU on the ColdFusion (jrun.exe) server
spikes to 100% and stays there until the CF service is restarted.
The database server seems to be working correctly as applications that directly
The default admin account so to speak is called "sa" not system. Try that.
Also, Id recommend putting a password on just in case :-)
Mike
_
From: Dwayne Cole [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 8:08 PM
To: CF-Talk
Subject: MS SQL Database Con
com> cc:
Subject: MS SQL Database Connection
08/01/2004 12:07
I beginning to MS SQL developers edition on my development laptop and I'm running in to problems setting the database through ColdFusion Administrator. During the setup I use "localhost" for the server and for the user name I'm using "system" and I'm leaving the password blank. I did not set up
Thanks to Jon for his help on this, I've got a database connection going and actually run a good SQL query from within HomeSite with JScript. But now I'm trying to dig down and extract the database schema, which is what I'm really after.
I'm trying to rewrite this VBScript,
ShazButt?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Problem solved - changed the fonts to SMALL under display - settings -
advance
-Original Message-
From: Shahzad.Butt
Sent: 01 October 2003 10:21
To: CF-Talk
Subject: DWMX Database Connection
I've set up RDS and can view my datasourcees in Dreamweaver.
Problem is
that the
I've set up RDS and can view my datasourcees in Dreamweaver. Problem is
that the font (font size) is weird and I cannot read anything. I can
click on a datasource by guessing and then i can see tables as well but
font is so weird that I am unable to read anything. Can someone tell me
how to make i
Thanks Steve, I'll give that a go, btw we are on win2K server & IIS5Alex-Original Message-From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 13:55To: CF-TalkSubject: RE: CFMX and SQL Server database connection problemsWe had a similar problem when we g
and SQL Server database connection problemsYes, we've got SQL server running in mixed mode (we did this when weupgraded on of our other servers to MX) and I;ve checked the passwords a fewtimes ;-) I'm not sure that its a password problem because cf admin usuallytells you it's a login fail
Yes, we've got SQL server running in mixed mode (we did this when weupgraded on of our other servers to MX) and I;ve checked the passwords a fewtimes ;-) I'm not sure that its a password problem because cf admin usuallytells you it's a login failure, but we're getting timeout errors AlexCheck y
A.Little wrote:> > We've just upgraded a couple of our development servers from CF5 to CFMX> (6.1) and we're having problems getting CFMX to connect to MS SQL2K> databases on another server. When we were using CF5 (behind firewall) we> could connect fine to databases on 2 different servers (one be
Hi all, We've just upgraded a couple of our development servers from CF5 to CFMX(6.1) and we're having problems getting CFMX to connect to MS SQL2Kdatabases on another server. When we were using CF5 (behind firewall) wecould connect fine to databases on 2 different servers (one behind thefirewall a
I have serveral websites that use ColdFusion.
When one of the sites upgraded to CFMX, the database connection seems not to
work. My support person is looking into the problem.
All pages that are database driven do not work. The following is an example
http://www.sfaevalsite.com/tmcite-eval
with Access database connection
I'm trying to connect to an Access 2000 database on our network. The
file is on a file server in the same domain as our Intranet. I have the
ColdFusion MX app server logging in as my own domain account, which has
full access to the database. Connecting to
Elvis has fell oot the building
-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]
Sent: 24 March 2003 23:45
To: CF-Talk
Subject: RE: Problem with Access database connection
Try this:
http://www.forta.com/cf/tips/index.cfm?age=169
==
Peter Tilbrook
Internet
Have you checked it?
Do you get errors?
What's the "problem" ?
>>| -Original Message-
>>| From: Sangeeta Karmokar [mailto:[EMAIL PROTECTED]
>>| Sent: Tuesday, March 25, 2003 12:29 AM
>>| To: CF-Talk
>>| Subject: Problem with Access datab
CAn anyone check this script
I am trying to create login and Password page with access as my database. Can u check
whether this script is ok?
SELECT*FROM log
WHERE Login='#form.Login#'
AND Password='#form.Password#'
~
823
Facsimile: +61 (02) 6213 7287
-Original Message-
From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 March 2003 9:55 AM
To: CF-Talk
Subject: Problem with Access database connection
I'm trying to connect to an Access 2000 database on our network. The file
is on a
I'm trying to connect to an Access 2000 database on our network. The file
is on a file server in the same domain as our Intranet. I have the
ColdFusion MX app server logging in as my own domain account, which has full
access to the database. Connecting to local databases works fine. The
databas
Sent: Monday, March 03, 2003 10:51 PM
To: CF-Talk
Subject: RE: Database Connection
just goin for the obvious here, have you verified
the user/pass combo...is it SA and blank password, or did
you set it up to be something? did someone change it, is it
set up for mixed mode auth? (integrated window
Double Down, Inc. wrote:
> I get the following error when I try to go to any cold fusion page in my site. The
> error reads:
>
> Error Executing Database Query.
> SQLException occurred in JDBCPool while attempting to connect, please check your
> username, password, URL, and other connectivity
-Original Message-
From: Double Down, Inc. [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:48 PM
To: CF-Talk
Subject: Database Connection
I get the following error when I try to go to any cold fusion page in my
site. The error reads:
Error Executing Database Query
I get the following error when I try to go to any cold fusion page in my site. The
error reads:
Error Executing Database Query.
SQLException occurred in JDBCPool while attempting to connect, please check your
username, password, URL, and other connectivity info.
I have checked the SQL serv
Bob Haroche wrote:
>
> This is possible, but not recommended, especially if it is a
> multi-user database. To do so, however, clear the cached connection
> information with the following code:
>
>
With CF MX, you need to disable the datasource and then restart the
DataSourceService.
http://sp
uncheck
> "Maintain Database Connection" for the datasource and they came up with
> some BS answer that it keeps multiple connections being made. Isn't it
> just for efficiency so CF doesn't have to connect every time a call is
> made? Through the host's user interface
> I've tried putting up a bogus page with an invalid SQL
> query. Isn't that supposed to release it?
That works for me provided the bogus query in fact returns an error.
Another way to go is to use the following undocumented tag, which I've never
tried. But here's an excerpt from a post a while
Can someone clear this up for me. I maintain a site on a shared server
and it uses access :-(. Seems every time I need to alter the mdb file
it's locked on the server. I've asked the hosting company to uncheck
"Maintain Database Connection" for the datasource and they came up
I am getting the above error message when I try to connect to my sql database. I have
tried everything I can think of and now at a complete loss.
I'm using Windows 2000 Professional and sql Server 2000 (plus SP 2) and ColdFusion 5.
Here's what I've done:
CF Administrator verifies the connecti
Hallo,
Database Connection Polling and Page compilation &
caching are the feature of ColdFusion.
How can i use Database Connection Polling in
Coldfusion(the way of use)?
How can i use Page Compilation & caching in
Coldfusion(the way of use)?
T
;" <[EMAIL PROTECTED]>
Newsgroups: gradwell.lists.cftalk
Sent: Wednesday, May 30, 2001 11:40 AM
Subject: Maintain Database connection?
> Hi
>
> Just a quick questions regarding the Maintain Database Connections in
> Access,
> should this be checked or unchecked and
://www.fusioneers.com
http://www.warrick.net
> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 30, 2001 3:36 AM
> To: CF-Talk
> Subject: Maintain Database connection?
>
>
> Hi
>
> Just a
Hi
Just a quick questions regarding the Maintain Database Connections in
Access,
should this be checked or unchecked and if it is unchecked what are the
performance
implications?
Thanks
KOla
~~
Structure your ColdFusion code with Fusebox. Get th
Lloyd,
Lotus has a product called LEI that you can use to query data from ODBC
data sources (SELECT, INSERT, etc.). We use it in some of our Notes apps
to get data from our AS400 as well as a SQL server.
Best regards,
Rob
>>>Thanks to everyone who responded. It is disappointing that no one h
my two cents,
Albert.
-Mensaje original-
De: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Enviado el: jueves, 17 de mayo de 2001 19:10
Para: CF-Talk
Asunto: RE: CF-Notes database connection
If there is a OBDC driver for Notes then you can uses MD SQL DTS to import
the data into MS SQL
Rif
mming in Notes and
SQL Server.
Good Luck,
Shaun Blain
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 5:28 AM
To: CF-Talk
Subject: CF-Notes database connection
Thanks to everyone who responded. It is disappointing
If there is a OBDC driver for Notes then you can uses MD SQL DTS to import
the data into MS SQL
Rif
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 20:00
To: CF-Talk
Subject:RE: CF-Notes database connection
I haven't d
>build a web intermediary between Notes an CF.
>
>-Original Message-
>From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
>Sent: 17 May 2001 17:43
>To: CF-Talk
>Subject: Re: CF-Notes database connection
>
>
>
>Well, in Notes you can use LotusScript. Out of Not
Surely with Domino 5 and it's flashy wizzy web side you must be able to
build a web intermediary between Notes an CF.
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 17:43
To: CF-Talk
Subject: Re: CF-Notes database connection
Well, in Note
need the capability to read from Any sort of
>database.
>
>Thanks,
>Tony Hicks
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: CF-Talk <[EMAIL PROTECTED]>
>Sent: Thursday, May 17, 2001 7:28 AM
>Subject: CF-Notes database connection
>
>
&g
ou're trying to do. maybe it's a start.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 5:28 AM
To: CF-Talk
Subject: CF-Notes database connection
Thanks to everyone who responded. It is disappointing that no one has had
any
t;[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 7:28 AM
Subject: CF-Notes database connection
>
>
> Thanks to everyone who responded. It is disappointing that no one has had
any
> success in doing what we are needing to do, which is exchanging dat
Thanks to everyone who responded. It is disappointing that no one has had any
success in doing what we are needing to do, which is exchanging data between
Notes and our SQL Server database. We just wanted to get names, addresses,
phone numbers, etc. out of our db and into the Notes Personal Ad
;Jon
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, May 15, 2001 1:00 PM
>To: CF-Talk
>Subject: CF-Notes database connection
>
>
>
>
>I investigated the CF-Talk archives and found a very brief mention of this
>
CF-Talk
Subject: CF-Notes database connection
I investigated the CF-Talk archives and found a very brief mention of this
last
December, but am wondering if anyone else has had any experience with
getting
data into or out of a Lotus Notes database. I downloaded Lotus' NotesSQL
driver, install
I investigated the CF-Talk archives and found a very brief mention of this last
December, but am wondering if anyone else has had any experience with getting
data into or out of a Lotus Notes database. I downloaded Lotus' NotesSQL
driver, installed it, created a DSN, and verified it in CF Admin
On 2/6/01, Haryono ... penned:
>Hi everyone.
>I don't understand about Database Connection Pooling.
>What is the meaning of Database Connection Pooling?
To the best of my knowledge: You can choose to maintain connections
when you set up a datasource in CF Admin. You can also ch
Hi everyone.
I don't understand about Database Connection Pooling.
What is the meaning of Database Connection Pooling?
What is the meaning of page compilation and caching?
Thank you.
~~
Structure your ColdFusion code with Fusebox. Get the off
Hallo everyone.
I get a problem when I was reading about ColdFusion's
feature.
One of Coldfusion feature is Database Connection
Pooling.
I don't understand about Database Connection Pooling.
Can someone help me to explain about that(detail)?
I want to ask something?
What is the meani
mechanism is often required
to manage access to these variables from multiple threads within an
application. Mutexes are the synchronization mechanism to insure that data
integrity is preserved.
Database connection pooling spreads the connection overhead across several
user requests by establishing
Hallo everyone.
I want to ask some question.
What is the meaning of Database Connection Pooling in
the coldfusion's feature?
What is the meaning of Multithreaded in the
coldfusion's feature?
Thank's for your answer.
~~
Structure
about OLE-DB -- How to set up a SQL Server 7 database
connection?
I'm mystified at how to go about setting up a native
connection to SQL Server 7 databases using OLE-DB
datasources. I've looked at all the docs I could find
but the information available to me thus far is sparse
an
I'm mystified at how to go about setting up a native
connection to SQL Server 7 databases using OLE-DB
datasources. I've looked at all the docs I could find
but the information available to me thus far is sparse
and I'm left perplexed. Can someone give me a hand?
My SQL Server's name is "warlo
se". Put a check in that
box and see if that helps.
Todd Ashworth
- Original Message -
From: "Boris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 10:15 AM
Subject: FW: CF not letting go of database connection?
| Yes, the database
ase. Are you speaking in reference to SQL Server by any
chance?
Todd Ashworth
- Original Message -
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 11:12 AM
Subject: RE: CF not letting go of database connection?
| I w
Original Message-
From: Todd Ashworth <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, September 01, 2000 10:03 AM
Subject: Re: CF not letting go of database connection?
>Do you mean that the database engine stays running even after the last
>co
Yes, the database connection on my server remains open even after the
session has been closed. I'm looking at my DSN, but the Sybase 5.5.04
driver doesn't have that option. I've tried in my CF 4.0 Administrator to
set the Limit database connection inactive time to 1 minute, that
:-)
-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 2 September 2000 12:10 AM
To: [EMAIL PROTECTED]
Subject: Re: CF not letting go of database connection?
Do you mean that the database engine stays running even after the last
connection has been closed?
If so, go
it will have to restart every time a
new query comes along, which adds about 1 second of overhead (YMMV).
Todd Ashworth
- Original Message -
From: "Boris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 31, 2000 1:20 PM
Subject: CF not letting go
941-574-8600 Ext. 210
-Original Message-
From: Boris [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:21 PM
To: [EMAIL PROTECTED]
Subject: CF not letting go of database connection?
I have a number CF based pages that once the query is completed with the
data presented it
let go of the database connection to my Sybase
>SQL Anywhere database. Even after the page has been exited.
>
>Any suggestion would be appreciated.
>
>Boris
>
>--
>Archives: http://www.mail-archive
/00 -0700, you wrote:
>I have a number CF based pages that once the query is completed with the
>data presented it will not let go of the database connection to my Sybase
>SQL Anywhere database. Even after the page has been exited.
>
>Any suggestion would be apprec
ailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:21 PM
To: [EMAIL PROTECTED]
Subject: CF not letting go of database connection?
I have a number CF based pages that once the query is completed with the
data presented it will not let go of the database connection to my Sybase
SQL Any
I have a number CF based pages that once the query is completed with the
data presented it will not let go of the database connection to my Sybase
SQL Anywhere database. Even after the page has been exited.
Any suggestion would be appreciated.
Boris
> Does anyone know how CFTRANSACTION and database connection pooling
> interact?
>
> My specific question is: If I wrap a series of SQL commands (some
> creating temp tables, some updating temp tables, some querying those
> same tables) within a CFTRANSACTION tag, does CF S
1 - 100 of 101 matches
Mail list logo
