This is a bit of a long question; I hope I can find a patient expert! But I want to make my problem as clear as possible ...
I am writing a simple database application in Delphi, running on a Microsoft Access database. The handling of data and the front face design are going wonderfully, and those tasks are well within my capabilities; what I have trouble with is setting up the various technical connections needed to make the things work in the first place.
My initial question on this app (about unwanted Login prompts) showed I wasn't really aware of how the blessed components connected in the first place:
... and now since having that question answered, I have happily written most of the app. But now when I release it to a few beta-test people they get a message saying "An error occured while attempting to initialze the Borland Database Engine (error$2108)". I was unaware I was actually USING the BDE (my ignorance of this kind of technical understructure would fill books) and given some of the problems I understand it causes, I would rather NOT use the BDE.
However I have written the entire app based around a TDatabase, and a TQuery ... only it turns out the TQuery is descended from TBDEDataset, which drags the whole BDE thing in. I am only using SQL access to the database anyway.
My question is basically: is there a simple database handling system in Delphi where I can just drop something on the screen and have a Query run SQL through it? I neither want nor need to get into all this technical stuff about BDE and ODBC ... it just seems to me that someone at some stage must have thought "hey, why don't we just write a MicrosoftAccessDataHandler
Object and be done with it?" ... does such a thing exist? If not, what alternatives are there? What is the SIMPLEST way of handling a database in an application?
Parameters: the app has a database onboard but it does NOT connect to the web, nor is it even networked beyond being accessible from different computers (that is, only one computer can be signed in to it at any one time) ... I am using Delphi 7 ... I have Access 2002 ... now that I have written so much, the solution MUST tie in to an object similar to a TQuery (i.e. one that has an SQL property that I can fill and then execute it).
Given that there could be varying points of view on this one, I have allotted a reasonable amount of points so I can subdivide if necessary. I'll close it in 80-odd hours.