GuyWithDogs
User
Fresh Boarder
| Posts: 1 |   |
Karma: 0
|
|
Retrieving data, creating everything at run-time?
|
|
Posted: 2007/05/18 10:36 |
|
|
|
|
I took my first look at AnyDAC yesterday, using it with BDS 2006. I went through the Getting Started PDF, and modified the ADConnectionDefs.ini, etc. and was able to link to my database and fill a DBGrid.
But what I really want/need to do is create a program (which is intended to eventually end up as a Windows service) that will connect to various MySQL databases on a known server, based on incoming data files from external sources. Basically, machines will upload log files, and my service will find the new ones, do some data crunching, and then put the data in various databases.
There isn't a visual part to this, and since this will run on machine at "customer sites", we want to hide and/or encrypt the connection information as much as possible. So I really don't want to have an INI file with the connection information laying around - I've already got something to house that information securely.
Is is possible to establish the network connection, dataset, etc. all at run-time? Can I create these things dynamically, as needed, and fire my data through them when I have data, and then free the connection until the next time there's a file to process? If so, is there an example of how to do this?
|
|
