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 do you set traceflags in dbexpress SQL Monitor

Am I right that traceflags do not work in SQLMonitor? I have been trying to use them in XE2 with Firebird and it looks to me like they have not been implemented at all. The published properties of TSQLMonitor has traceflags commented out. …
Steve
  • 98
  • 6
3
votes
1 answer

Delphi dbexpress MySQL query format

I am using Delphi 2010 dbexpress components to connect to my MySQL database. I am facing a problem executing this query. SQLQuery1.SQL.Clear; SQLQuery1.SQL.Add('Select ForNo,Description from fortab'); SQLQuery1.Open; It gives me an error…
Shirish11
  • 1,587
  • 5
  • 17
  • 39
3
votes
1 answer

dbExpress and SQL Server 2008 slow

I recently migrated from Delphi 7 with SQL Server 2000 to Delphi 2010 with SQL Server 2008. I am using dbExpress. After installing the new version I have found that the on sites that have a lot of data that system has become slow and unstable. Can…
user734781
  • 273
  • 1
  • 9
  • 19
3
votes
3 answers

How can I connect to an Oracle database as SYSDBA using dbExpress?

I have a Delphi application that connects to an oracle database. When I try to log in as SYSDBA, I get the error: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER When I try to log in with a user of "SYS AS SYSDBA", I get the…
JosephStyons
  • 57,317
  • 63
  • 160
  • 234
3
votes
2 answers

Delphi7, dbExpress and Master Detail relationship

I'm new to Delphi. I got two TSQLTables (say A and B) linked to two TClientDataSets (say cdsA and cdsB respectively) by two TDataSetProviders, two DataSources (dsA and dsB) complete the scenario. Let A be the master one and let B be the detail…
Francesco
  • 1,742
  • 5
  • 44
  • 78
3
votes
2 answers

dbExpress vs native Drivers

I was reading Holgerwa's question and I have a question. Is there any significant performance improvement by changing from dbExpress to other driver specific? Can we use dbExpress and still use specific DB engine features?
Jlouro
  • 4,515
  • 9
  • 60
  • 91
3
votes
1 answer

How do I keep my program responsive to user input while executing a DBExpress query?

ibdac query ( http://www.devart.com/ibdac/components.html ) has a function executing where I can write something like: while MyQuery.Executing do begin application.ProcessMessages; Sleep(1); end; how do I implement the same code with a…
ae1080
  • 374
  • 2
  • 7
  • 14
3
votes
1 answer

Connecting to MySQL via SSL, using DBExpress

I want to connect to a MySQL server via SSL. More specifically, I want to do that with DbExpress. I've used SSL to MySQL via ZeosLib in the past. That worked great, but Zeos doesn't let me run stored procedures that return more than one resultset,…
Wouter van Nifterick
  • 23,603
  • 7
  • 78
  • 122
3
votes
1 answer

DBXPool Corrupts Memory on Failure to Connect

When DBXPool is used for the DelegateConnection on a TSQLConnection, if SQLServer is unavailable when you call the TSQLConnection.Open method, it will timeout the first time. But if you subsequently call Open again, it will misbehave. In my…
James L.
  • 9,384
  • 5
  • 38
  • 77
3
votes
1 answer

Only One field shown from SQL

I have a problem trying to get fields from a SQL statement that retuns 2 fields If I run the query in phpMyAdmin, it returns all the fields correctly. That means SQL statement is correct If I run the SELECT statment with only one field, it returns…
Duilio Juan Isola
  • 237
  • 2
  • 10
3
votes
1 answer

Auto-truncate assigned string to the length of the field?

I met a problem when migrating dbexpress driver from 10 to 11. I have the following codes to execute an update statement in SQL Server: sql.add('UPDATE mytable SET myfield=:AFIELD'); ParamByName('AFIELD').AsString := 'Some random string that is too…
user700582
  • 31
  • 1
  • 2
3
votes
3 answers

How to fix 'Unable to find record. No key specified'?

I'am using a firebird 2.5 server to write in a Database file(BD.fbd). My delphi XE8 project has a Data module(DMDados) with: SQLConnection (conexao) TSQLQUery1 (QueryBDPortico_Inicial) + TDataSetProvider1 (DSP_BDPortico_Inicial) + TClientDataSet1…
Johnny Arza
  • 53
  • 9
3
votes
2 answers

Windows Authentication in Firebird 2.5

Can I login to firebird database using a Windows user instead of using SYSDBA and MASTERKEY credential? If Yes, please let me know the way to connect to the firebird database. I am using Delphi XE3 and Firebird 2.5. I need to authenticate user by…
Vinod_cmdl
  • 49
  • 9
3
votes
0 answers

RAISERROR doesn't return correct error message using DB Express on Windows 10

I am running my application which is developed in Delphi 10.1 berlin Update 2 on windows 10 and it is accessing the Database through network (I am using SQL Server 2016 and it is installed on different machine), when stored procedure raises error…
Sajith Nair
  • 31
  • 3
3
votes
2 answers

Max length TSQLConnection.Params values

Hello fellow StackOverflowers, Currently I'm facing a situation where it seems that there is a maximum length for the Database property of a TSQLConnection object in Delphi. When I open the connection to my database I get the following error when I…
RFerwerda
  • 1,267
  • 2
  • 10
  • 24
1 2 3
…
17 18