Stack Overflow
Stack Overflow

Questions tagged [dbexpress]

dbExpress is Embarcadero's data driver architecture replacing the deprecated Borland's BDE.

dbExpress is Embarcadero's data driver architecture that replaced the older Borland Database Engine ().

It only provides unidirectional database access.

Embarcadero supplies drivers for many notable databases. Additional drivers are also available from third parties.

Currently, drivers can be written in Delphi/C++.

Resources:

  • Migrating BDE Applications to dbExpress page on Embarcadero Developer Network.
  • Wikipedia article on dbExpress
  • DevArt page on their proprietary dbExpress drivers.
254 questions
38
votes
1 answer

Is there a trick for using TSQLMonitor with a TSQLConnection that uses the new ODBC dbExpress driver?

I have been testing the new ODBC dbExpress driver that ships with Delphi XE2, and have noticed that the TSQLMonitor does not seem to work. Thinking that I may have configured the component incorrectly, I hooked up a TSQLMonitor to a TSQLConnection…
Cary Jensen
  • 3,554
  • 2
  • 29
  • 49
16
votes
3 answers

How to make Firebird client application wait for row to unlock

My familiarity is with the Microsoft SQL server world using ADO (dbGo), and I have written many applications for that environment. Now I have a legacy Delphi 7 application with a Firebird 2.5 database that I must maintain. BUT I am finding is that…
nolaspeaker
  • 1,868
  • 19
  • 38
14
votes
4 answers

How can I get the table description (fields and types) from Firebird with dbExpress

I have written a tool for displaying database structures using the GetTableNames and GetFieldNames methods of TSQLConnection. How can I get the types of each field name similar to the following list (which is part of the DDL required to build the…
No'am Newman
  • 5,936
  • 5
  • 33
  • 48
11
votes
3 answers

How long does a TDataset bookmark remain valid?

I have code like below in a project I'm working. procedure TForm.EditBtnClick(Sender:TObject); begin // Mark is form variable. It's private Mark = cdsMain.GetBookmark; // blabalbal . . . end; procedure…
Fabricio Araujo
  • 3,868
  • 1
  • 25
  • 40
7
votes
5 answers

Firebird: DBExpress or native components?

I am starting with Firebird and have found components to access a database by Devart. They offer native components (IBDAC) or DBExpress drivers. (I am using Delphi XE2 Pro which doesn't include Firebird drivers) I guess native components are a bit…
Holgerwa
  • 3,398
  • 7
  • 40
  • 49
7
votes
3 answers

Memory leak with Delphi/DBExpress

I've a weird problem with my application, its memory usage goes up a few hundred megabytes at once every now and then and eventually the application freezes. The application is written with Delphi, it uses database, COM (for OPC) and TCP/IP. With…
Harriv
  • 5,877
  • 6
  • 40
  • 73
7
votes
8 answers

Database connectivity Delphi

I'm using delphi for years, but never for database stuff, but recently started researching and testing. I must say, i'm impressed, most of things happens automatically, i'm used to write by hand in php and python. i'm going to develop a commercial…
arthurprs
  • 3,985
  • 2
  • 23
  • 28
7
votes
2 answers

Delphi 2009 and Informix dbExpress with Windows 2003

I have simple application that uses dbExpress to connect Informix database. If I compile it with TurboDelphi it works on both WinXP and Win2003. When I use new Deplhi 2009 my app works ok on WinXP but do not start on Win2003. No MessageBox with…
Michał Niklas
  • 48,759
  • 16
  • 62
  • 100
7
votes
1 answer

How do I set up DBX connection pooling in code?

I've got Delphi XE Professional. It comes with a fair amount of DBX stuff, including the DBXPool unit that contains the connection pooling support, but it doesn't have the full DBX support that comes in XE Enterprise. In particular, a lot of the…
Mason Wheeler
  • 77,748
  • 42
  • 247
  • 453
6
votes
1 answer

Statically link firebird driver for dbexpress

Is it possible to deploy zero-dll executable that connects to Firebird using dbExprss? If so, how? Cause I've tried to include DBXFirebird but the executable always needs dbxfb.dll. Thank you all.
helloworld0101
  • 140
  • 1
  • 7
6
votes
6 answers

Is it possible to create databases programmatically using DBX?

Looks like the TSQLConnection only connects to existing databases, and I could not find another component that allows me to send commands to the database server. I'm using Delphi 2009 with Firebird and MSSQL. One idea that came was to connect to a…
Erick Sasse
  • 2,649
  • 3
  • 23
  • 29
6
votes
3 answers

dbGo or dbExpress for Delphi 2010 with Microsoft SQL Server

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…
Snackmoore
  • 895
  • 2
  • 16
  • 32
6
votes
2 answers

dbExpress/No key specified

I am working on a database program, using the dbExpress components (Delphi 7). The data is retrieved from the database via the following components: TSQLDataSet -> TDataSetProvider -> TClientDataSet -> TDatasource -> TDBEdit. Until now, the form…
No'am Newman
  • 5,936
  • 5
  • 33
  • 48
5
votes
2 answers

List of free dbexpress drivers for Delphi

Anyone knows/has a comprehensive list of free open source dbexpress drivers?
user114285
  • 503
  • 6
  • 19
5
votes
3 answers

Can dbExpress's TSQLQuery use ? as parameters?

We've porting code to Delphi XE2, and need to change our data access components from third party ODBCExpress which is no longer in business, to dbExpress's TSQLQuery. We have parametrized SQL query such as: sSQL := 'UPDATE ZTestData SET '+ '…
Robo
  • 4,290
  • 7
  • 37
  • 46
1
2 3
…
16 17