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.
259 questions
3
votes
0 answers

How can I check if a memory leak exists the dbexpress components?

In a very simple expample VCL project (1 form, 1 grid, 1 simpledataset) I'm requesting data from a random table from a Micorosft SQL Server using dbexpress Data.DBXMSSQL. I've enabled memory leak reporting with ReportMemoryLeaksOnShutdown := true;…
ventiseis
  • 3,029
  • 11
  • 32
  • 49
3
votes
1 answer

Check if database has support for transactions using FireDac

How can I check if the DBMS has support for Transactions, using FireDac components? Usually, I use something like the follow code, to perform a transaction in my DAO class, using dbExpress. ... connection: TSQLConnection; dbxTransaction:…
rodrigopandini
  • 945
  • 1
  • 7
  • 18
3
votes
2 answers

Connecting SQL 2008 at runtime

I'm trying to connect at runtime with SQL Server 2008 with Delphi 2009 using DBExpress, it's not working. When I set all the properties at design time, it works great, but at RunTime, I'm getting "unknown driver: mssql". Below is the code: …
Pascal
  • 2,944
  • 7
  • 49
  • 78
3
votes
1 answer

How to mark all TClientDataSet records as Inserted?

I have a complex transaction that saves data from multiple TClientDataSets in database. One of those ClientDataSets always append data to underlaying table, eg. generate INSERT statements, regardless of where existing records came from. I'm forcing…
dmajkic
  • 3,448
  • 1
  • 18
  • 24
3
votes
1 answer

Delphi, dbExpress and UTF8

We've just upgraded our MySQL server from 5.0 to 5.1. The remaining task is to finally sort out our Unicode support, which has been troubling us since Delphi 2010. We are now using XE5. The new database has been set up with default collation as…
Dan Kelly
  • 2,634
  • 5
  • 41
  • 61
3
votes
7 answers

Multiple Database Access with Delphi

I´m a 10 years FirebirdSQL user, and now i have a customer wanting to use MSSQL 2008. I don´t want to start flame wars with this, i just want your advice on data access tecnology. Im using Delphi MMVI. Use native ADO or DBExpress? Use third…
José Eduardo
  • 323
  • 1
  • 5
  • 16
3
votes
2 answers

Firebird inserts very slow

I have problem with slow executing of INSERT statements on Firebird database. Performance values are as follows: Inserting 3800 records on notebook with Windows XP takes around 31 seconds (~ 120 inserts per second). On another PC with Windows 7 32…
truthseeker
  • 31
  • 1
  • 5
3
votes
2 answers

Files required for dbexpress application to access mysql databases

Which additional files are needed to deploy a delphi dbexpress based application to get access to mysql databases. I can't find any information about it. Thanks in advance.
Francis Lee
  • 975
  • 8
  • 23
3
votes
1 answer

How to open ClientDataSet (master/detail) in separate thread(different of main thread)

Using: Delphi XE2, DBExpress, Firebird I can't access any VCL control outside the main thread safely, that includes forms, panels, edits, etc and the Timage and Timage descendants. I'm need to open ClientDataSet (Master/Detail) in separate…
dataol
  • 999
  • 3
  • 19
  • 42
3
votes
1 answer

Snappy DBExpress SQL Executor method

Given the following {------------------------------------------------------------------------------} function TTestClass.NewQuery(const ASql : String) : TSqlQuery; begin Result := TSqlQuery.Create(FConn); Result.SQLConnection := FConn; …
Hugh Jones
  • 2,706
  • 19
  • 30
3
votes
1 answer

Why does reconnecting to an Oracle database via dbExpress cause an access violation?

I have a Delphi 2006 application running on Windows 7 that connects to an Oracle database via dbExpress using an Oracle 11 client install. After the first connect, I can query data and everything works as expected. However, when I disconnect and…
PersonalNexus
  • 1,292
  • 1
  • 9
  • 25
3
votes
2 answers

Delphi TDBXTransaction 'Invalid transaction Object'

1st off I am new to Delphi so this may be a "mundane detail" that's being over looked. [sorry in advance] I am getting an 'Invalid Transaction Object' error when I attempt to run a transaction through a datasnap server connected to an Oracle 11g DB.…
Troy Harris
  • 435
  • 1
  • 14
  • 21
3
votes
0 answers

How to optimize sql-handling executing through dbxmss.dll/sqlncli.dll?

A table defined on my MS SQL Server (2008R2) is defined as follows: create table stagefm.dbo.article (id nvarchar(10)); I send a simple insert statement to my MS SQL Server through dbexpress (dbxmss.dll): Q.SQL.Text:= 'INSERT into…
Peter Sawatzki
  • 173
  • 7
2
votes
1 answer

EIBInterBaseError 'unavailable database' when trying to create a Firebird database in Delphi

I'm trying to create a Firebird database during runtime. The procedure that I'm using to do this is this one: procedure CreateDatabase(DBName: String); var IBDatabase1: TIBDatabase; begin IBDatabase1 := TIBDatabase.Create(Self); try …
ivarec
  • 2,542
  • 2
  • 34
  • 57
2
votes
5 answers

How to execute a SQL script using dbExpress?

I'm migrating an old Delphi application (using ZeosDB) to Delphi XE2. I want to use dbExpress as a ZeosDB replacement for database access to Firebird 2.5 or MS-SQL. There are a lot of sql scripts for creating tables, view and stored procedures I…
cytrinox
  • 1,846
  • 5
  • 25
  • 46
1 2 3
…
17 18