The below code works in Delphi 2007, but it gives me this error in Delphi 2010: --------------------------- Error --------------------------- Cannot load oci.dll library (error code 127). The oci.dll library may be missing from the system path or you may have an incompatible version of the library installed. ---------------------------...
Hello Folks, 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. ...
I have a Firebird database (running on server version 2.1.3) and am connecting to it with Delphi 2007 using the DBExpress objects (using the Interbase driver) One of my tables in the database looks something like this CREATE TABLE MYTABLE ( MYDATE Timestamp NOT NULL, MYINDEX Integer NOT NULL, ... Snip ... PRIMARY KEY (MYDAT...
Hi, I am planning to migrate a Delphi 6 BDE application to Delphi 2010... First of all, do I have to move away from BDE? (I will but I prefer to do this in stages if possible) Second, is dbExpress the best choice? (I am using MS SQL) Lastly, is there an equivalent of TUpdateSQL in dbExpress? (or anything else) I have a lot of codes ...
Hi! Sorry for my english, but i hope you'll understand me :P I'm trying to create new TSQLQuery component in code, without placing it on form. I wrote that code: var sql:tsqlquery; pole:TFMTBCDField; .... sql:=tsqlquery.Create(self); sql.SQLConnection:=ddm.konekszyn; sql.SQL.Text:='SELECT COUNT(idrap) FROM raporty WHERE idkie...
Hi Everyone, I am migrating to Delphi 2010 and I am using Microsoft SQL 2000 (Planning on upgrading to SQL2008). I have been using BDE all along and wondering if I should use dbGo (ADO) or dbExpress with my future application. Can someone explain to me the pros and cons for using either one? Thanks a lot. ...
Hi Everyone. I have an environment with Delphi 2010 + SQL Server 2000 +Windows 7 (RC) for i am testing it on Windows 7... When I try added a new dbExpress connection for SQL Server and press "Test Connection" from the data explorer, I'll get the following message:- Borland.Data.TDBXError: DBX Error: Driver could not be properly initia...
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 part? Any other words of wisdom? Thanks, yes i know that i will have to rewrite procedures, ...
Some days ago I posted a question on which component to use to make a MultiDatabaseWithJustOneComponent and i follow the general advice to use dbexpress. FirebirdSQL has date field, SQL Server 2008 has date fields too. But for some reason date fields are converted to TWideStringField, and when I'm trully confident that I've seen all e...
I use RAD Studio 2010 including latest updates 4 and 5, my database is SQL Server Express. I set up a TSQLConnection but it won't connect, error message is "DBX-Error: the driver could not be initialized correctly. A client library may be missing, may not be installed correctly, or may have the wrong version" (error messagetranslated fr...
hello all I am trying to use dbexpress component first time to connect to mysql i got this error Failure to Connect : Unable to load libmysql.dll my delphi version : Delphi7 mysql 5.1.36 (wamp server installed on my windows). can any one help me in this thanks in advance ...
The Firebird FAQ explains how to create a BOOLEAN domain. Probably the most interesting part is at the end, where it says: If you use a connectivity library like OleDB under .Net, you can override the OleDB provider's GetSchema method, so the DataTables you get from queries have native .Net booleans. Is there any way to do...
I am using DBExpress with blackfish. How can I do multi Transaction? I have several GRIDs all in editing at once and all will have to be saved at once. The begin editing and post are to be determined by the end user, as he works, and in different place of the application, so difficult to do in one only transaction. UPDATE: OK the pr...
I've got some code that builds a map (graph) of rooms on a grid with links between them. It's stored in a Firebird database with rooms in one table and links in another. The data is managed through DB Express TSimpleDataset datasets. The query for the Exits (links) table looks like this: select EXITS.*, r1.x as x, r1.y as y, ...
I’m using the new C++ builder 2010 and I’m upgrading a c++ program from c++ builder 6. I have a case sensitive data database (SQL Server 2000) using the collation SQL_Latin1_General_CP1_CS_AS I’m moving the data components from BDE to dbExpress. Using profiler I can see that when the components query systables / get Meta data its searc...
being a dbExpress newbie I wonder if there is a dbExpress driver for Microsoft Access? ...
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 inserts right now with: // Create temp table, assign all target data, // Empty targe...
I'm using delphi for years, but never for database stuff, but recently started researching and testing. I must say, i'm impressed, most of things happens automatically, i'm used to write by hand in php and python. i'm going to develop a commercial system for a friend, (2 layers) 5 user computers, 1 database server. Database server wi...
This is probably a really simple question, but here it is. I just renewed my license for the DevArt DBExpress driver for Firebird. The help file says I can use their freeware DBMonitor application with it but since I am using D2006, I have to use these instructions: "If you are Delphi Pro version user, then you don't have TSQLMonitor ...
Currently, our database uses Win1252 as the only character encoding. We will have to support Unicode in the database tables soon, which means we have to perform this migration for four databases and around 80 Delphi applications which run in-house in a 24/7 environment. Are there recommendations for database migrations to UTF-8 (or UNICO...