<DIV>Thank you Frank for your kind help.</DIV>
<DIV> </DIV>
<DIV>I still have some issues though..</DIV>
<DIV> </DIV>
<DIV>I don't understand which syntax I should use.. I am trying something like </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV> CONNECTIONTYPE OGR<BR> CONNECTION "C:\Programmi\Apache Group\Apache\htdocs\abruzzo\maps\data\comuni_abruzzo_gb.shp"<BR> DATA "SELECT * FROM comuni_abruzzo_gb LEFT JOIN 'MYGIS:database=zzzz_abruzzo, tablename=zzz, user=rt, password=rt, port=3306' ON comuni_abruzzo_gb.Id = zzz.ID"</DIV>
<DIV> </DIV></BLOCKQUOTE>
<DIV dir=ltr>But I get this error: </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><STRONG>Warning</STRONG>: [MapServer Error]: msDrawMap(): Failed to draw layer named 'comuni'. in <B>c:\programmi\apache group\apache\htdocs\abruzzo\_test_mysql.php</B> on line <B>117</B><BR><BR><B>Warning</B>: [MapServer Error]: msOGRFileOpen(): ExecuteSQL(SELECT * FROM comuni_abruzzo_gb LEFT JOIN 'MYGIS:database=zzzz_abruzzo, tablename=zzz, user=root, password=slbenfica, port=3306' ON comuni_abruzzo_gb.Id = zzz.ID) failed. SELECT from table MYGIS:database=zzzz_abruzzo, tablename=zzz, user=rt, password=rt, port=3306 failed, no such table/featureclass. in <B>c:\programmi\apache group\apache\htdocs\abruzzo\_test_mysql.php</B> on line <B>117</B><BR><BR><B>Fatal error</B>: Call to a member function on a non-object in <B>c:\programmi\apache group\apache\htdocs\abruzzo\_test_mysql.php</B> on line <B>118</B></DIV></BLOCKQUOTE>
<DIV dir=ltr>Besides I am just gessing as I don't know the syntax rules.. could you giveme a hand on this or tell me the place where I can find this syntax?</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Thank you so much</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Joao<BR><BR><BR><B><I>Frank Warmerdam <fwarmerdam@GMAIL.COM></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">On 5/4/05, jo˙ffffffffffe3o Antunes <BLUETUNA_GOES_SKYING@YAHOO.CO.UK>wrote:<BR>> Now the challenge is: I am transfering this system to LINUX environment and<BR>> as far as could get so far I still have to use an ODBC connection... is this<BR>> true? I mean beeing in LINUX environment souldn't I be able to make a direct<BR>> connection between mapserver an MySQL without having to use a windows native<BR>> technology? <BR>> <BR>> I am afraid I might be making things more complex than they could be.. <BR>> <BR>> thanks in advance for any tips. <BR><BR>Joao, <BR><BR>On Linux (or windows for that matter) you can access MySQL either<BR>via ODBC or via a direct MySQL connection depending on how your<BR>package is built. The direct MySQL driver is minimally documented at:<BR><BR>http://www.gdal.org/ogr/drv_mysql.html<BR><BR>I find it easier to build OGR directly
against MySQL and use that<BR>instead of ODBC on Linux where ODBC can be pretty hairy. <BR><BR>Note that in your example you were using a shapefile. That <BR>configuration should work fine on Linux too. <BR><BR>Best regards,<BR>-- <BR>---------------------------------------+--------------------------------------<BR>I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com<BR>light and sound - activate the windows | http://pobox.com/~warmerdam<BR>and watch the world go round - Rush | Geospatial Programmer for Rent<BR></BLOCKQUOTE><p>
<hr size=1><font face="Arial" size="2">How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. <a href="http://us.rd.yahoo.com/mail/uk/taglines/default/photos/*http://uk.photos.yahoo.com/"><b>Get Yahoo!
Photos</b></a></font>