Questions tagged [bde]

BDE is the abbreviation for Borland Database Engine.

Borland Database Engine (BDE) is a legacy Windows-based database engine providing database connectivity for Delphi and C++ Builder via SQL Links and ODBC.

It was replaced in 2000 by dbExpress.

Resources

180 questions
0
votes
0 answers

Delphi 7, ADO, Reading binary data in BLOB fields in "DBase IV" table. How to disable transliterate?

I'm using Delphi 7 and ADO (TAdoTable component). I need to read binary data from "DBase IV" table (dbf/dbt) using ADO. Binary data is stored in BLOB fields. This table was previously created programattically by BDE (TTable component was used).…
0
votes
4 answers

BDE, DB2 and TQuery parameters

DISCLAIMER: This is legacy code and I simply can't rewrite everything (trust me, I would like to). I'm trying to execute a legacy Delphi app which uses BDE and DB2, but I simply can't run parametrized querys. QueryA.SQL.Text := 'select count (*)…
Rafael Ibraim
  • 1,515
  • 2
  • 12
  • 13
0
votes
0 answers

General SQL error when accessing TDatabase on C: drive, but not on other drives

I have a Delphi program with a piece of code like this: var FDatabase : TDatabase; ... (create and configure Fdatabase) ... FDatabase.Connected := True; On most machines in runs without problems, but for some win7 machines I get the…
0
votes
2 answers

Why DefaultExpression property work only with BDE?

How can I use DefaultExpression property for TField with MS Access or SQL Server, it seems to work only with BDE.
Kachwahed
  • 542
  • 7
  • 17
0
votes
1 answer

Reading dBase with BDE makes too many file handles

I want to read dbase files from a remote pc. The problem is this makes very many file handles. This is a code example that does this. I do it in a thread, because I want to read more files parallel at the same time. using (OleDbConnection oleCon =…
FloFlo
  • 1
0
votes
3 answers

Loading BDE BPL from another directory

Using Delphi 2010 and a patched version of the BDE I run into a problem loading the BDERTL140.bpl. Loading DCLBDE140.bpl from another directory then usual works fine. Only when I want to load the BDERTL140.bpl, it always tells me that it has been…
Ralph M. Rickenbach
  • 12,893
  • 5
  • 29
  • 49
0
votes
3 answers

Pass parameter by "in" Delphi

I need to pass a parameter to a SQL in Delphi using BDE to be using an "in", the example below: select * from customers where id in (:p_in) I need to pass: p_in a list of customers. But Query.ParamByName.('p_in').AsString: = '1, 2,3 ', and it did…
Tiedt Tech
  • 719
  • 15
  • 46
0
votes
2 answers

Operation must be an updateable query - VB Script, Paradox Table

I'm using a Win XP box with BDE Administrator and Access 2007 installed. I'm able to open and perform select queries on existing Paradox tables without problem but have some very strange behavior when attempting INSERT/UPDATE. I can even create a…
0
votes
2 answers

Delphi - TStoredProc.Close (does it empty the set?)

LEGACY ALERT - This is for Delphi 5 code. (I know it is super old. It is scheduled to be rewritten.... Some day.) I am using the BDE and the TStoredProc object. When I call Close, this normally clears my dataset. However, I am seeing weird…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
0
votes
4 answers

C#+BDE+DBF problem

I have huge problem: I have lots of .dbf files(~50000) and I need to import them into Oracle database. I open conncection like this: OleDbConnection oConn = new OleDbConnection(); OleDbCommand oCmd = new OleDbCommand(); …
user174303
0
votes
3 answers

Delphi 7 BDE on SQL Server 2012

Searched the net in and out and could not find proper info on that, we have a legacy setup that uses Delphi 7 and BDE to connect to SQL Server 2005. Now we are planning to migrate to SQL Server 2012, what are the chances that it might work or not?
Sin5k4
  • 1,556
  • 7
  • 33
  • 57
0
votes
2 answers

project "ctsMgr.exe" raised exception class EDBEngineError with message "unknown database. Alais:.."

I was running a Delphi(4) exe . It ran well for few seconds, then raised the error project "ctsMgr.exe" raised exception class EDBEngineError with message "unknown database. Alais:PerDBS". Process stopped. Use Step or Run to…
vas
  • 2,078
  • 9
  • 39
  • 60
0
votes
1 answer

Delphi 7 : How to search BDE database field for certain keywords

I am very new to Delphi and created a simple BDE database with the following fields: Entry number, System, Error, Solution. I want to be able to search the 'Error' field for any keyword(s) and all the entries that contain that keyword should be…
0
votes
1 answer

Delphi BDE Issue $2501

Possible Duplicate: BDE initialization failure (error $2501) on Vista These days our client keep encountering the BDE issue with error code $2501 when trying to open two instances of application share the same alias An error occurred while…
Leo.W
  • 299
  • 1
  • 7
  • 21
0
votes
1 answer

Export Delphi BDE Paradox *.db Query Result to a text file?

How to export Delphi BDE Paradox *.db Query Result to a text file? e.g. I use SQL Explorer or Database Dekstop in Borland Delphi and the query like : SELECT * FROM mst_employee; and I want the result of the query in a text file say mst_employee.txt…
user1210396
  • 309
  • 1
  • 6
  • 13
1 2 3
11
12