I'm trying to populate a TDBGrid with the results of the following TQuery against the file Journal.db: select * from Journal where Journal.where = "RainPump" I've tried both Journal."Where" and Journal.[Where] to no avail. I've also tried: select Journal.[Where] as "Location" - with the same result. Journal.db is a file created by a...
I ported a Delphi 6 application to Delphi 2007 and it uses BDE to connect to an Oracle 9i database. I am getting an "ORA-01426: numeric overflow exception" when I execute a stored procedure. This happens randomly and if I re-run the stored procedure through the application with the same parameters the exception does not occur. The old D...
Please note the Edit below for a lot more information, and a possible solution We recently modified a large Delphi application to use ADO connections and queries instead of BDE connections and queries. Since that change, performance has become terrible. I've profiled the application and the bottleneck seems to be at the actual call to...
Here's the situation: A user of our program suddenly started receiving an error from the Borland Database Engine (BDE) when attempting to start the application. The error message says that it was unable to initialize the BDE and gives error code $251e. User is on BDE 5.2.0.2. I cannot find any official documentation on the error $251...
I am attempting to convert a Dephi 2006 project to Delphi 2009 (Delphi 2006 is on Drive C Delphi 2009 is on Drive D). On the main form there is a DataSource1: TDataSource; and a Table1: TTable; In OnFormShow the table filename is set to: TableFilename := IncludeTrailingPathDelimiter( MyProfileFolder ) + 'Delphi 2009\Projects\Adirondac...
I am converting an application from BDE to ADO. Under the BDE, if a query was Open and you called "Sql.Clear", it would automatically close the dataset. However, this is not the case under TADOQuery, where it will raise an exception "Operation cannot be performed on a closed dataset". A lot of our legacy code relies on the old BDE beh...
Hi, i have two applications (server and client), that uses TQuery connected with TClientDataSet through TDCOMConnection, and in some cases clientdataset opens about 300000 records and than application throws exception "Temporary table resource limit". Is there any workaround how to fix this? (except "do not open such huge dataset"?) up...
What is the Differences between ado and bde? ...
Logged into my Windows XP SP2 computer using my normal user account (which has Local Admin privileges), when I start the BDE Administrator -- either from the Control Panel or from the BDEADMIN.EXE directly -- I never get the GUI. It shows up on my task bar, and shows up in the Task Manager, but the GUI never appears. I can close the pr...
I was wondering - is there a standard (like a RFC) for the .sch schema file format the BDE uses? The format is described here and here. It seems based on this Microsoft format, but it's not quite the same. Example 1 - VARYING format file CUSTOMER.SCH: [CUSTOMER] Filetype=VARYING Delimiter=" Separator=, CharSet=ascii Field1=Customer ...
In my Delphi7 app, I can connect to the database when logged in as Administrator ("Dave"), but not when logged in as a standard or limited user ("Paris"). Happens on XP Home & Vista Business Ultimate 64. I use an alias for the db. Database is Firebird, middle-ware is IBO 4.7. I posted this in another thread, but know I have a lot more i...
I have a small datasnap server written in Delphi 2007 that accesses the BDE. It works fine on Windows 2000 and XP but from time to time (actually quite regularly) on Vista I get the error message: An error occurred while attempting to initialize the Borland Database Engine (error $2501) Closing everything down that uses the BDE fixes ...
We have a application that uses BDE connected to an Oracle DB. I use TQuery for the SQL queries, and it connects to TDatabase, we are not professional programmers, and we don't know what happens under the hood. Our network is unstable, we have an issue with packet loss. When the problem occurs, our application disconnects from the DB s...
There is a software which is using BDE for its database activities. The database is very awkwardly designed. I have to build a few custom reports that will use the data generated by this software. I have a need to skip a few records based on a few conditions. Like for example if Field4 and Field5 = 0 then that record should not be pr...
I have some tables being used with the Borland Database Engine that I need access to in C#. But I don't see the BDE as an available Data Source. Is this because it's not doable or something else. If anyone has any info or links to provide on how this is done I would appreciate it. Thanks ...
We have a big program, using BDE + oracle, developed by delphi, We use 3 threads to do DB operations, they are using separated TSession. (1 deamon thread, 1 data collect thread, 1 checking thread) We use this structure: TQuery -> TDatabase -> TSession We use this method to do query: try qu.close; //TQuery qu.sql.clear; qu....
i have one problem when i run my program in delphi7 have one error message "unknown table type - permission denied - file:c:\PDOXURS.NET direcory C:\" i dont know of make tk for one answer ...
Hello All! 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 continue. Does the above error imply that Database named "perDBS " is undefined? Should ...
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(); oConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + directory + ";Extended Propertie...
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 things happen so I thought I would ask this question. If I have manually added rows to the da...