OGR-join problem with DBF files

[Rainer Spittel]

Hi Frank,

  thanks for the fast reply.

  I called 'ogrinfo' as you have described before and it's working fine. I
receive a joined output of both files, the shapefile and the dbf.

  But the mapserver part is still not running. I added the following lines:

   CONNECTIONTYPE OGR
   CONNECTION "ms_wasser/baden/badeseenbremen"
   DATA "SELECT * FROM badeseenbremen LEFT JOIN bade ON
badeseenbremen.GewaessNr = bade.GewaessNr"

  and receive following error message:

  Warning: [MapServer Error]: msDrawMap(): Failed to draw layer named
'Baden'. in D:\ms4w\apps\wasser_2.0\ms_digitalmap_inc.php on line 755

  Warning: [MapServer Error]: msOGRFileOpen(): Open failed for OGR
connection `ms_wasser/baden/badeseenbremen'. File not found or unsupported
format. in D:\ms4w\apps\wasser_2.0\ms_digitalmap_inc.php on line 755

  Fatal error: Call to a member function on a non-object in
D:\ms4w\apps\wasser_2.0\ms_digitalmap_inc.php on line 757

  When the CONNECTION tag does not link directly to a shape-file (ending
with .shp), I get this message.

  I also tried to add the exact sql statement of the ogrinfo statement and
it is not working.
  I am still not sure what I can do...

Cheers

Rainer