<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE>font-face {
FONT-FAMILY: Tahoma
}
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2>The SQL Server provider is intented to work with datastore
created with Map 3D 2007 inside SQL Server 2000 and 2005.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2>It has it's own geometry storage and spatial indexing
mechanism. Although it could reverse engineer existing database, this
would be done for non-spatial data only as it has no mean to identify geometry
property in the database.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2>In case you have X,Y,Z coordinates stored in different
columns, the ODBC provider should be used against SQL Server
data.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2>Just wanted to make sure the provider was not being used
for what it was not design for.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=584443213-04102006><FONT face=Arial
color=#0000ff size=2>RF</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Lockyer James
[mailto:James.Lockyer@bradford.nhs.uk] <BR><B>Sent:</B> Wednesday, October 04,
2006 2:59 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server 2005<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText99100 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Supported yes - does it
work... now that's the question.</FONT></DIV>
<DIV dir=ltr><BR> </DIV>
<DIV dir=ltr>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr><FONT face=Tahoma size=2><B>From:</B> Gord McKenzie
[mailto:gord.mckenzie@canam.com]<BR><B>Sent:</B> Tue 03/10/2006
22:04<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server 2005<BR></FONT><BR></DIV></DIV>
<DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Thanks</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Warren
Medernach [mailto:warren.medernach@imaginit.ca] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, October 03, 2006 1:33
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
users@mapguide.osgeo.org<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [mapguide-users] SQL Server
2005</SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Hello
Gord,</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">I was informed by the
ADN that the FDO provider supports: SQL Server 2000 (SP4) and SQL Server
2005.</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Warren
Medernach</SPAN></FONT></P></DIV></DIV></BODY></HTML>