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 error, only info in EventLog: Faulting application inf_dbexpress_test.exe, version 0.0.0.0, fa...
I am having a problem getting a list of fields from a query defined at run time by the users of my program. I let my users enter a SQL query into a memo control and then I want to let them go through the fields that will return and do such things as format the output, sum column values and so forth. So, I have to get the column names s...
I have a query in Delphi using DBExpress TSQLQuery that looks like so ActiveSQL.sql.add('SELECT * FROM MYTABLE where MYFIELD=(:AMYFIELD) '); ActiveSQL.ParamByName('AMYFIELD').AsString := 'Some random string that is to long for the field'; ActiveSQL.Open; If I run it, when it executes the open command I get the following exceptio...
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 system database (master or tempdb in MSSQL for example) and then send create commands to ...
I need to create a Firebird Database programmatically using DBExpress. I have done this for SQL server, by first connecting to Master, then passing in the script for Create to a query, but with Firebird I have a little chicken and egg problem. ...
Hi everybody, i've setup a demo to test datasnap 2009, and i've got a problem with dbexpress. The dbexpress error message, (same at design time or runtime) : "Cannot load oci.dll library (Error code 127). The OCI.dll library may be missing from the system path." I'm using Oracle 8.0.5. The path to oci.dll (c:\orant\BIN) is in my syste...
I have only done "GUI" database access in Delphi with DbExpress components, but now I'd like to execute one query on background. I read some where that TSQLConnection is not thread safe and I have to create new connection for each thread. I see that there's CloneConnection in TSQLConnection, but help claims that new connections are owned...
I am trying to use auto incremental fields in dbx4 with a black fish database I have a simple table Structure: CREATE TABLE tblTABname ( ID int AUTOINCREMENT Primary Key, Description varchar(100) NOT NULL ); Before Open I am doing the : qryTAB.FieldByName( ‘ID’).AutoGenerateValue := arAutoInc; cdsTAB.FieldByName( ‘ID’).Au...
I'd like to monitor SQL queries executed by my application while it runs. I'm using a dbExpress connection to an Oracle 11g database under Delphi 2007. This used to be possible under the BDE with the sqlmon.exe utility. Is there a similar utility for dbExpress? I've tried the Toad SQL Monitor, which logs two or three queries and then...
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 error: ORA-01017: invalid username/password; logon denied How can I log in as sysdba using a db...
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 TForm.OkBtnClick(Sender:TObject); var mistakes: Integer; begin //Validation stuff and transaction control //remo...
Using the standard Delphi dbexpress dbexpora.dll + oci.dll (10g) (the oracle instantclient is installed). When directly on the Oracle Database box we can run dbexpress apps just fine. The local dbxconnections.ini alias used in that case simply specifies our DB service name ORCL as the "database" parameter. We are trying to connect to t...
I am hitting an brick wall during normal SQL processing, When connected to Oracle 10g from a remote client w/DBEXPRESS, - using the standard dbxpora.dll + oci.dll When in a transaction, after exactly 255 record insertions, the connection hangs for 30 seconds and returns the error: ORA-03114 (as if it lost the connection...) This h...
I need a dbx driver for mysql. It should be free. Open source is appreciated. (delphi 7+ and mysql 5+) ...
Anyone knows/has a comprehensive list of free open source dbexpress drivers? ...
In the AfterPost event handler for a ClientDataSet, I need the information if the ApplyUpdates function for the current record will do an update or an insert. The AfterPost event will be executed for new and updated records, and I do not want to declare a new Flag variable to indicate if a 'update' or ' insert' operation is in progress....
I have had Delphi 2007 for a while. I tried the Delphi 2009 trial. Then I un-installed the trial. Now I get this in a dbExpress Delphi 2007 application: --------------------------- Debugger Exception Notification --------------------------- Project ABC.exe raised exception class TDBXError with message 'Unable to load dbxora.dll (Err...
is there a free standalone editor for DBExpress connections (Delphi 2009) that can be installed on a customer PC and be used to manage DBExpress connections and (if available) drivers? ...
I have an older application (written in Delphi 6) that has to be ported to Delphi 2006 (update 2). The application used to connect to an Interbase 6.x database using DBExpress, but the new version needs to connect to a Firebird 2.x Superserver. Porting went OK, no real problems. But now, when I try to connect to the new Firebird server ...
Hello Folks, Like every year I receive a new Delphi version as SA owner and this is what I do : Install delphi version XX. Run delphi version XX Insert a TSQLConnection component. Connect it to a Microsoft SQL Server 2000 who will be with us at least for six more years. Insert a TSQLQuery with a 'select top 1 * from myTable' which is...