Thread

ODBC Driver for AW db? (Bots)

ODBC Driver for AW db? // Bots

1  |  

archon manus

Feb 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 fleming

Feb 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 manus

Feb 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 fleming

Feb 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 manus

Feb 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 fleming

Feb 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 sarkozy

Feb 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 manus

Feb 6, 1999, 9:07am
[View Quote]
Thanks, I appreciate your searching for it :)

Archon Manus

1  |  
Awportals.com is a privately held community resource website dedicated to Active Worlds.
Copyright (c) Mark Randall 2006 - 2021. All Rights Reserved.
Awportals.com   ·   ProLibraries Live   ·   Twitter   ·   LinkedIn