<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>ADO is fine if speed is not an issued..
i.e.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>Oracle table with child table ADO Components 5 seconds per
scroll</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>MSSQL speed not as noticable </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>MySQL Buggy (more cos of the ODBC Drivers
etc)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>Postgres as with MySQL</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>Also for installation of the application on the client
machines, With ADO the ODBC Drivers need to be installed also (and
sometimes the DSN) although it is my practice to use DSNless
connections,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>Whilst with the DBXpress or SQLDirect type components no
installation is required on the users machines, This is prevelent in my
work environment WAN where my Application (plus very small dll's) are
distributed to each server to the same directory, anyone in the company from any
office (regular or visiting) can open the application and use it immediately..
(Centralised Database)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2>Yes third pary components I generally say NO WAY!!! however
these tools/drivers are for both C#, and Delphi languages and the company's
selling them seem to want to keep it compatible with the changes
in Delphi. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=222395319-11102004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> delphi-bounces@ns3.123.co.nz
[mailto:delphi-bounces@ns3.123.co.nz] <B>On Behalf Of </B>Jeremy
Coulter<BR><B>Sent:</B> Monday, 11 October 2004 3:58 p.m.<BR><B>To:</B>
delphi@delphi.org.nz<BR><B>Subject:</B> [DUG] ADO or SQLDirect
?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma; BACKGROUND-COLOR: white">Hi
All. </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma; BACKGROUND-COLOR: white">I am
just doing a bit of an investigation at the moment, and wonders what others had
found was best to talk to an MSSQL server with Delphi. </DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma; BACKGROUND-COLOR: white">Do
you use ADO? or do use controls that talk to the MSSQL API like SQLDirect
?</DIV>
<DIV
style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma; BACKGROUND-COLOR: white"> </DIV>
<DIV
style="FONT-SIZE: 10pt; FONT-FAMILY: tahoma; BACKGROUND-COLOR: white">Thanks,
jeremy</DIV></BODY></HTML>