SQL Server 6.5 & IB 1.5

Article View: borland.public.intrabuilder.data.sql

Article #73

Back to borland.public.intrabuilder.data.sql Previous Next

#73

From: Danny R. Gray
Date: Fri, 15 May 1998 00:00

29 lines
1542 bytes

I am using IntraBuilder 1.5 C/S with SQL Server 6.5 sp 4.  I have an
HTML page with links to my application reference tables, i.e.
department, Instructor, etc..  While switching from row to row in a form
for a reference table then to other forms for different reference
tables, I get the message from SQL Server that the database connection
failed, Max User Connections is exceeded. My questions are as follows:

How do user connections get created in IB?  Is it each form you open
after you launch your browser session?  Is is each query object on the
form? 

When are the connections released?  Does a connection get released when
you open a form for a different table or is it when your browser session
ends?

How are User Connections managed when you instantiate a form using
_sys.run()?

I know that I can set the User Connections higher, but performance and
resources on my server will take a hit.

Can you explicitly close connections? 

-- 
Danny R. Gray
Research Technician
Department of Pathology
UNC-CH School of Medicine

Technical Details

Message-ID: <355C5408.72CC45E3@med.unc.edu>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,a6953e755c7e80ed,start
X-Google-Attributes: gid101d9a,public
From: "Danny R. Gray" <drgray@med.unc.edu>
Subject: SQL Server 6.5 & IB 1.5
Date: 1998/05/15
Message-ID: <355C5408.72CC45E3@med.unc.edu>
X-Deja-AN: 353526344
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: UNC-CH School of Medicine
Mime-Version: 1.0
Newsgroups: borland.public.intrabuilder.data.sql