ThreadBoard ArchivesSite FeaturesActiveworlds SupportHistoric Archives |
ODBC Driver for AW db? (Bots)
ODBC Driver for AW db? // Botsarchon manusFeb 5, 1999, 9:55pm
Anyone know if there is an ODBC (or RDO, ADO or MDAC) driver for the
database that AW uses, and where it can be found? Thx, Archon Manus Vizier D'Magienne jim flemingFeb 5, 1999, 10:14pm
Do you mean for the data cached on the clients ?
....or the objects in the AW Servers (i.e worlds) Jim Fleming Unir Corporation [View Quote] archon manusFeb 5, 1999, 11:39pm
Ahh, good distinction. . .I meant a local driver for the database used by
the AW server, since I run a world server on a personal machine. In other words, a driver that will allow me to read and write the world server database directly from an application running on the same machine as the world server. A cache driver might be of use as well, but I don't see as many applications, at the moment. Archon Manus [View Quote] jim flemingFeb 6, 1999, 3:11am
[View Quote]
In the spirit of the "bot architecture" a software
subsystem can sit on a machine and inject a bot into the world to read and write the objects in the shared space. That software subsystem would then have the ODBC interface. Maybe some sort of scripting or trigger language would be used to drive that "bot". Rather than try to re-engineer the AW Server with a back-door interface via ODBC to an SQL server, it seems easier to use the front-door (so to speak) that the browser, bots and other client programs use. The SDK provides access via that front-door. In this arrangement the AW Server is not changed. It still stores objects in the shared space. The SQL data base can be used to augment that shared object space. In some designs the data to and from the database may flow via the description field while the rest of the AW object is not touched and is maintained by the AW server. An simple example might be a grid of sign objects the descriptions on the signs could come from the data base. The signs might be arranged in the VR space as a grid to be viewed by an AV that somehow launches a query. Or, it might be more simple, like the Arrival/Depature Schedule signs in airports. The pictures and some of the words here might help to fill in some of the blanks... http://www.objectshare.com/products/dst/info/dst.htm Jim Fleming Unir Corporation archon manusFeb 6, 1999, 3:53am
I understand and appreciate your SQL bot design and intend to use it as soon
as possible. My question was unrelated and remains unanswered, though. . .I would like to access the AW Server database of my world directly. Is there a known ODBC (or related) driver that will allow me to do this? Archon Manus Vizier D'Magienne jim flemingFeb 6, 1999, 4:23am
I assume that you mean real-time access with
interactive updates visible via the browser and database back-end tools. If that assumption is correct, then I am not sure there is an interface. That is why we are working on the front-door approach. If you are interested in a more macro level view without much timeliness to the data, then you have to stop the server, run a quick propdump to a text file and then restart the server. From there, you would have to load that ASCII text into your database with any conversions as needed. Jim Fleming Unir Corporation P.S. I have seen reference to a database product accessing the .dat and .idx files. I will go look for that reference. [View Quote] andras sarkozyFeb 6, 1999, 4:46am
No - there is NO way to access the server database while it is running.
Andras [View Quote] > I understand and appreciate your SQL bot design and intend to use it as soon > as possible. My question was unrelated and remains unanswered, though. . .I > would like to access the AW Server database of my world directly. Is there a > known ODBC (or related) driver that will allow me to do this? > > Archon Manus > Vizier D'Magienne archon manusFeb 6, 1999, 9:07am
|