🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #652

Re: deployment

#652
From: Craig Stuntz TeamB
Date: Fri, 19 Oct 2007 13:47
31 lines
2240 bytes
Eddie wrote:

> What is the solution ?

	You *cannot* use the BDE for an ISAPI DLL. 

	You should connect via TCP/IP and localhost when the ISAPI DLL and the
IB server are on the same machine.

	Borland *doesn't* promote the BDE/SQL Links. It's been depreacted for
years.

	This is actually not hard if you:

1) Use supported connectivity components.
2) Realize that ISAPI DLLs are by definition multi-threaded and follow
the usual rules for multi-threading in Delphi, and:
3) Follow the well-documented and extremely simple rules for connecting
to IB 6 from concurrent threads in a process, namely that you use
separate database connections per concurrent threads.

	With all that said, IB 6 predates Server 2003 by several years, and
hence was never supported on Server 2003. This is *not* what is causing
your problem, but can cause others (notably, slow connections) down the
line.

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Borland newsgroup denizen Sergio Gonz�lez has a new CD of 
  Irish music out, and it's good: http://tinyurl.com/7hgfr
Technical Details
Message-ID: <4718b557@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <47161c08@newsgroups.borland.com> <47161fd2$1@newsgroups.borland.com> <4718865e@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,61703e87f1af5fe
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII
From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]>
Subject: Re: deployment
Newsgroups: borland.public.interbase.sql
References: <47161c08@newsgroups.borland.com> <47161fd2$1@newsgroups.borland.com> <4718865e@newsgroups.borland.com>
Organization: Vertex Systems Corporation
User-Agent: XanaNews/1.18.1.5
X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 64.199.116.234
Message-ID: <4718b557@newsgroups.borland.com>
Date: 19 Oct 2007 06:47:03 -0700
X-Trace: newsgroups.borland.com 1192801623 64.199.116.234 (19 Oct 2007 06:47:03 -0700)
Lines: 31
X-Authenticated-User: cstuntz
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail