<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=344035917-17022006>Hey
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=344035917-17022006>With some tweaking
of ogrmysqllayer.cpp and pcrtypes.h I was able to get the daily build of feb 13
to compile and link on a windows xp system using visual c
6.0.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=344035917-17022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=344035917-17022006>I used to ogr2ogr to
create the Geometry_Columns table and I created a spatial_ref_sys table as
described in: <A
href="http://home.gdal.org/projects/osvecdb/sfsql-schema.html">http://home.gdal.org/projects/osvecdb/sfsql-schema.html</A></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=344035917-17022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=344035917-17022006>I altered the
geometry_columns so that the srid column was a foreign key from the spatial ref
table.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=344035917-17022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=344035917-17022006>I am still not
having luck having ogrinfo reflect the srid information I entered. I even
made sure that data I entered using the Geomfromtext function included the
srid. My question is whether I am doing something wrong or if I should
wait for a later build to be released before the spatial_ref_sys table is
supported??</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=344035917-17022006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=344035917-17022006>Thanks in
advance,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=344035917-17022006>Joe
Miller</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=344035917-17022006></SPAN></FONT> </DIV></BODY></HTML>