[Mapserver-users] Mapserver Postgis connection issues

[Swaminathan, Gayathri]

Hi:

I downloaded the latest version of mapserver (4.2.1) from mapserver's site

I am using it a windows 2000 server running IIS...

Postgresql version 7.5 from Mark Ayland's snapshot...http://www.webbased.co.uk/mca/pgsql75win.zip

I have been able to compile install and run just shapefiles fine on this newer version..

If I added a Postgis layer however..I am having the mapserver cgi run indefinetely and locking up.

I have checked/tried the following:

1) Checked for multiple instances of dlls and verified.
2) Checked if my query ran fine with psql and it works fine
3) I am able to connect to my postgresql database using PGADMIN AND EMS2 POSTGRESQL MANAGER.
4) Checked for my data statement issues...

Here is the layer I am trying to get mapserver work on

### SEWERLINES (SELECTED) ###
LAYER 
	GROUP "CIP Features"
	CONNECTIONTYPE postgis
	CONNECTION "user=postgres dbname=mydb host=myhostname"
#	Data is written on the fly from calling form.
	DATA "the_geom from (select oid,* from sewerline where GEO_CIP='SEWL001') as foo using unique gid using srid=4326"

	NAME sqlSewerline
	TYPE LINE
	STATUS OFF
	PROJECTION #GEOGRAPHIC NAD83
		proj=longlat
		ellps=GRS80 
		no_defs 
	END
	CLASS#
		NAME "Sewer lines (Selected)"
	    COLOR 200 0 0 
		#COLOR 200 251 187
		SIZE 2
	END
	METADATA
		legend_order "200"
		"NoID" "1"
		"NoLabels" "1"
	END

Am I missing something obvious? Thanks for all the help in advance.

Gayathri