In two words...
Use MTS (otherwise you get serious hassles with transactions).
MSSQL7 still uses DbLib, unless you use ADO which is a whole different
learning curve. That means only one cursor per connection which means speed
and transaction issues - or lots of code to do multiple sessions - and
transaction hassles.
MTS is surprisingly easy to do in Delphi (I mean really - really easy) and,
unless you run it on Win95/8 there are no downsides I've come across yet.
I'd still use another back-end tho'.
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
To: Multiple recipients of list delphi
Subject: [DUG]: FAQ's etc??
G'Day All,
Can someone point me in the direction of some FAQ's, Tips & Tricks,
Considerations when setting up MS-SQL7 to be accessed via Delphi 5 using the
BDE? I know how to do the connection etc. I'm just looking for some real
world experiences.
TIA
------------------------------------------------------------------------
--Donovan
Donovan J. Edye [www.edye.wattle.id.au]
Namadgi Systems, Delphi Developer
Web: www.namsys.com.au E-Mail: [EMAIL PROTECTED]
Voice: +61 2 6285-3460 Fax: +61 2 6285-3459
TVisualBasic = Class(None);
------------------------------------------------------------------------
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
