<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>ok, 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')</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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<BR>`z:/GIS/ESZBAT.DBF' required by JOIN.<BR><BR> 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?<BR><BR> Any ideas?<BR></DIV></FONT>
<DIV><FONT face=Arial size=2></FONT><BR> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Dejan.Gambin@pula.hr href="mailto:Dejan.Gambin@pula.hr">Gambin
Dejan</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=agomez@CCCMM.CESGA.ES
href="mailto:agomez@CCCMM.CESGA.ES">Alberto Gomez</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, June 03, 2005 9:16 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [UMN_MAPSERVER-USERS]
multiple join - shp to dbf</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=834411307-03062005><FONT face=Arial color=#0000ff size=2>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?</FONT></SPAN></DIV>
<DIV><SPAN class=834411307-03062005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=834411307-03062005><FONT face=Arial color=#0000ff size=2>I
really don't remember what my problem was but I wouldn't say it was "unable to
open secondary datasource"</FONT></SPAN></DIV>
<DIV><SPAN class=834411307-03062005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=834411307-03062005><FONT face=Arial color=#0000ff size=2>if I
can help you just say</FONT></SPAN></DIV>
<DIV><SPAN class=834411307-03062005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=834411307-03062005><FONT face=Arial color=#0000ff
size=2>dejan</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> UMN MapServer
Users List [mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf Of
</B>Alberto Gomez<BR><B>Sent:</B> Friday, June 03, 2005 9:19
AM<BR><B>To:</B> MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> Re:
[UMN_MAPSERVER-USERS] multiple join - shp to dbf<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hi Gambin,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> 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 "<FONT face="Times New Roman"
size=3>Unable to open secondary datasource `z:/GIS/ESZBAT.DBF' required by
JOIN". Is this your case?</FONT></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> Thanks in advance.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Alberto</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><BR> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=Dejan.Gambin@PULA.HR href="mailto:Dejan.Gambin@PULA.HR">Gambin
Dejan</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=MAPSERVER-USERS@LISTS.UMN.EDU
href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, June 03, 2005 8:59
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [UMN_MAPSERVER-USERS]
multiple join - shp to dbf</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=560465406-03062005><FONT face=Arial color=#0000ff
size=2>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</FONT></SPAN></DIV>
<DIV><SPAN class=560465406-03062005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=560465406-03062005><FONT face=Arial color=#0000ff
size=2>regards, dejan</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> UMN
MapServer Users List [mailto:MAPSERVER-USERS@LISTS.UMN.EDU] <B>On Behalf
Of </B>william paul<BR><B>Sent:</B> Thursday, June 02, 2005 4:16
PM<BR><B>To:</B> MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> Re:
[UMN_MAPSERVER-USERS] multiple join - shp to dbf<BR><BR></FONT></DIV>
<DIV>
<DIV>Hi:</DIV>
<DIV>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</DIV>
<DIV> </DIV>
<DIV>Does any one have a working example?</DIV>
<DIV> </DIV>
<DIV>Thank you in advance</DIV>
<DIV> </DIV>
<DIV>William</DIV></DIV>
<P>__________________________________________________<BR>Do You
Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection
around <BR>http://mail.yahoo.com
</P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>