multiple join - shp to dbf

[Alberto Gomez]

Messageok, i've got my mapserver and the shapefiles in the web server. I want to join a shapefile with a dbf file what is located in another server, so i have to get it trough '\\server\GIS\table.dbf'. That's my problem, with mapserver running in localhost it works great or when the dbf file is located in my HD, but when i try access from internet i get this error: (Z: disk is a mapping to a machine called 'server')


msOGRFileOpen(): OGR error. ExecuteSQL(SELECT fshape.*,fdbf.* FROM POLIGONOS fshape LEFT JOIN 'z:/GIS/ESZBAT.DBF'.ESZBAT fdbf ON fshape.POLIGONO = fdbf.POLIGONO) failed. Unable to open secondary datasource
`z:/GIS/ESZBAT.DBF' required by JOIN.

    I have tried with "\\server\gis..." but it no works. It seems to be a privileges problem as Emil advised to me and I've tried to change in IIS the IUSR_SERVER to access anonymously by a user who belongs to my domain, even with admin privileges, but with any result. What about folder permissions?

    Any ideas?



  ----- Original Message ----- 
  From: Gambin Dejan 
  To: Alberto Gomez 
  Sent: Friday, June 03, 2005 9:16 AM
  Subject: RE: [UMN_MAPSERVER-USERS] multiple join - shp to dbf


  I must admit I don't understand it quite well. dbf file is on the server but not web server? Your mapserver is on the web server and must have access to this dbf file?

  I really don't remember what my problem was but I wouldn't say it was "unable to open secondary datasource"

  if I can help you just say

  dejan
    -----Original Message-----
    From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of Alberto Gomez
    Sent: Friday, June 03, 2005 9:19 AM
    To: MAPSERVER-USERS at LISTS.UMN.EDU
    Subject: Re: [UMN_MAPSERVER-USERS] multiple join - shp to dbf


    Hi Gambin,

      I'm doing an one-to-one join with ogr conn too, but my problem is that my dbf file is in the server, not in the webserver. It tell me that is "Unable to open secondary datasource `z:/GIS/ESZBAT.DBF' required by JOIN". Is this your case?

     Thanks in advance.

    Alberto



     
      ----- Original Message ----- 
      From: Gambin Dejan 
      To: MAPSERVER-USERS at LISTS.UMN.EDU 
      Sent: Friday, June 03, 2005 8:59 AM
      Subject: Re: [UMN_MAPSERVER-USERS] multiple join - shp to dbf


      I am using CONNECTIONTYPE OGR and it works fine but this is for one-to-one join. I had some problems with JOIN clause in map file so I used OGR joins. I suppose this won't help you cause it seems only joins using JOIN clause in map file can be used for one-to-many joins. But I am not much experienced so I hope you will get some better answer

      regards, dejan
        -----Original Message-----
        From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of william paul
        Sent: Thursday, June 02, 2005 4:16 PM
        To: MAPSERVER-USERS at LISTS.UMN.EDU
        Subject: Re: [UMN_MAPSERVER-USERS] multiple join - shp to dbf


        Hi:
        I want to join a shp file with a dbf file. It's ONE TO MANY join. I have seen that more people have the same problem. Also I want to make a classification based on the attributes from the DBF file. I tried with OGR and JOIN OBJECT from Mapserver, but nothing

        Does any one have a working example?

        Thank you in advance

        William
        __________________________________________________
        Do You Yahoo!?
        Tired of spam? Yahoo! Mail has the best spam protection around 
        http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050603/6a553951/attachment.htm>