Hello everybody,
i'm in troubles and i hope you can help me.
I'm a beginner in pmapper and i have to solve a problem with a join to an
external ms-access database: join doesn't work, more over are the
explanations.
I've read the whole newsletter but usually talks about problems with
postgres and there are no useful examples for me. Even PEAR manual is too
short.
My machine (os: win xp) runs Mapserver for Windows (MS4W) v. 1.5.0 (the
package as is) and I've installed pmapper v.1.2.0 following the instructions
in the documentation
------------------------------
This is the layer interested in the join (map file extract):
# Start of Layer fabbricati
#
LAYER
NAME "fabbricatiGBO"
TYPE polygon
DATA "fabbricatiGBO"
METADATA
"DESCRIPTION" "fabbricati"
"RESULT_FIELDS" "IDF,FABBRI_N,FABBRI_T,FOGLIO_N,FOGLIO_T,ID1"
"RESULT_HEADERS" "Idf,Fabbri_n,Fabbri_t,Foglio_n,Foglio_t,Id1"
"RESULT_JOIN"
"odbc://'':''/localhost at daticatastali||SITUAZIF at [EMAIL PROTECTED] at
Cons||IDF||1"
END # Metadata
CLASS
Name 'fabbricati'
COLOR 252 205 104
OUTLINECOLOR 0 0 0
TEMPLATE void
END # Class
END # Layer
------------------------------
Here is the error in the error log file:
[27-Apr-2006 18:05:15] Could not connect to DB defined for Layer
'fabbricatiGBO'. Check map file entry for JOIN definition.
------------------------------
What i did:
I created a DSN file named 'daticatastali.dsn' pointing to the ms-access
database, but i don't know where to put it and if it has the right content.
Then I even created a user DSN.
I checked if PEAR's DB module was installed and i found it in
c:\ms4w\Apache\php\PEAR\DB
I tried to change the syntax in many ways but unsuccessfully.
I controlled that filed names were right.
------------------------------
My questions:
What's the right syntax for the "RESULT_JOIN" instruction?
Am I in the correct way?
Where i put the dsn file?
Do I have to use username 'admin' or change slashes or paths?
Thanks in advance
Greetings, antonio
