[Mapserver-users] OGC-compliant WMS-server delivering dynamic layers with MS?

[Frieso ter Haseborg]

Hi,

I'm searching for possibilities to use MS for building an OGC-compliant
WMS-service which creates and serves dynamic layers from data out of
RDBMS. These RDBMS do NOT have any spatial-extensions it's just the
"x,y-coordinate & label-data"-thing. 

So what I want to do: retrieve the coordinates from my databases and
create one or more dynamic layers. I did some experiments with
PHP/MapScript, no major problems so far, that seems to be the easier
part.

The problem comes here: I don't want to create these layers in any
client-app, I want to have these layers served by the mapserver, since I
have to incorporate other servers e.g. ArcIMS which have to use and
process this layers through OGC-requests. Any ideas?

Are there any possibilities to create dynamic layers from RDBMS e.g.
Sybase ASA, MS SQL Server, Oracle without spatial-extensions I
overlooked, besides doing this in PHP/MapScript?

Are there any hooks or entry-points in the mapserv-cgi to process
customized-operations like creating the mentioned dynamic layers?

Any comment and hint would be appreciated!

TIA,
 
Frieso ter Haseborg
- Software Development - 
 
--

-------------------------------------------------- 
S&F Datentechnik GmbH&Co.KG 
Reimersstr. 41b 
26789 Leer, Germany