dbGo or dbExpress for Delphi 2010 with Microsoft SQL Server

sql-server delphi delphi-2010 dbexpress
Snackmoore picture Snackmoore · Nov 18, 2009 · Viewed 8.6k times · Source

I am migrating to Delphi 2010 and I am using Microsoft SQL 2000 (Planning on upgrading to SQL2008). I have been using BDE all along and wondering if I should use dbGo (ADO) or dbExpress with my future application. Can someone explain to me the pros and cons for using either one?

Thanks a lot.

Answer

J__ picture J__ · Nov 18, 2009

I've recently had exactly the same dilemma, wondering whether to move away from ODBCExpress to ADO or dbExpress which are more supported out-of-the-box.

My decision was very simple in the end, as it was made for me: dbExpress is uni-directional, designed for executing queries, not for cursor-style movement through a dataset. You have to add extra support in order to use grids and other db-aware controls, by using the TDataSetProvider and TClientDataSet components. So it can be done but the extra layers ruled it out for me.

Zarko Gajic has an excellent article on it on his delphi.about.com site.

I'm sure others will disagree and that's good, I welcome the discussion.

Related questions

ms sql xml data type convert to text

in MS Sql there are data types that are not supported by delphi 7, the xml datatype is one example. I wish to convert the XML datatype to Text datatype, so that i could handle it in delphi. Is there a …

Read More
Connect Delphi to SQL database

I'm using Microsoft SQL Server R2 Express to create databases. When I try to connect to a database using delphi, I have to use this Connection string : ADOConnection1.ConnectionString := 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=db_formation;Data Source=…

Read More
Delphi: how to pass a list as a parameter to a SQL query?

I have a list of integers or of strings and need to pass it as a parameter for a Delphi DataSet. How to do it? Here is an example. MyQuery is something like: select * from myTable where intKey in :listParam …

Read More