Postgis-connection

[Vera Schulze]

poggensee.net wrote:
> I want to use a postgis database. the geometry lies in column 'the_geom' of
> table 'test'.  Now I got this error message:
> 
> msDrawMap(): Image handling error. Failed to draw layer named 'TEST'.
> prepare_database(): Query error. Error executing POSTGIS DECLARE (the actual
> query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
> asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from test
> WHERE the_geom && setSRID('BOX3D(4494500 5258000,4680500 5444000)'::BOX3D,
> find_srid('','test','the_geom') )'
> 
> Postgresql reports the error as 'ERROR: could not load library
> "C:/ms4w/apps/pgsql75win/lib/libpostgis.dll": error '
> 
> 
> what is my mistake ??? the mapfile seems to be OK.


Hi,

have you checked your SQL-statement directly in the database? Query 
error is most of the times a wrong sql-statement.
Is your conf-file ok?
If both are ok, post the layer code from your mapfile.

Hth,
Vera