<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags" xmlns:ns1 = "" xmlns:ns0 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]--><o:SmartTagType name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="Street"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="address"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@font-face {
font-family: Verdana;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"
}
H2 {
FONT-WEIGHT: bold; FONT-SIZE: 18pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
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
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=487351120-26042006><FONT face=Arial
color=#0000ff size=2>Unfortunately at this time ODBC is only working with MS
Access.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=487351120-26042006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=487351120-26042006><FONT face=Arial
color=#0000ff size=2>Dave</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> Chris White
[mailto:chris.white@keytraffic.com] <BR><B>Sent:</B> Wednesday, April 26, 2006
9:39 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B>
[mapguide-users] Problems with ODBC Connection to Foxpro
database<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I’m attempting to establish a
connection to a Foxpro database using Autodesk MapGuide
Studio.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I’ve created a system dsn and
created connection with Studio however when I press test connection I get the
following error:<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">System.Net.WebException: The remote
server returned an error: (559) MgFdoException.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> at
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetRequestToString(Operation
operation)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> at
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String
resourceId, String provider, String
connectionString)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> at
Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> at
Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.buttonTestConnection_Click(Object
sender, EventArgs e)<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">After reading other posts on this
matter I logged onto the mapagent and used the TestConnection functionality:-
This time I get the following error:<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<H2><B><FONT face="Times New Roman" size=5><SPAN style="FONT-SIZE: 18pt">An
exception occurred in FDO component. RDBMS: <o:p></o:p></SPAN></FONT></B></H2>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">An exception occurred in FDO component. RDBMS: Exception
occurred in method MgFdoConnectionManager.Open at line 840 in file
c:\build_tux_area\mgdev\server\src\common\manager\FdoConnectionManager.cpp<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Any ideas?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Thanks<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">Chris</SPAN></FONT><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<P><EM><B><I><FONT face=Verdana color=navy size=3><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Verdana">Chris
White</SPAN></FONT></I></B></EM><B><FONT face=Verdana color=navy size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana"><BR></SPAN></FONT></B><FONT
face=Verdana color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana">Software
Architect</SPAN></FONT><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<TABLE class=MsoNormalTable style="WIDTH: 80%; BORDER-COLLAPSE: collapse"
height=73 cellSpacing=0 cellPadding=0 width="80%" border=0>
<TBODY>
<TR style="HEIGHT: 12pt" height=16>
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; WIDTH: 100%; PADDING-TOP: 0cm; HEIGHT: 12pt"
vAlign=top width="100%" colSpan=3 height=16>
<DIV style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt">
<DIV class=MsoNormal><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">
<HR align=left width="100%" color=red noShade SIZE=1>
</SPAN></FONT></DIV></DIV>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P></TD></TR>
<TR style="HEIGHT: 42.75pt" height=57>
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; WIDTH: 38.2%; PADDING-TOP: 0cm; HEIGHT: 42.75pt"
vAlign=top width="38%" height=57>
<P class=MsoNormal
style="LINE-HEIGHT: 10pt; mso-margin-top-alt: auto"><B><FONT face=Verdana
color=navy size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Verdana">Key
Traffic Systems Ltd.<o:p></o:p></SPAN></FONT></B></P>
<P class=MsoNormal
style="LINE-HEIGHT: 10pt; mso-margin-bottom-alt: auto"><st1:Street
w:st="on"><st1:address w:st="on"><FONT face=Verdana color=navy
size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">Ardencroft
Court</SPAN></FONT></st1:address></st1:Street><BR><st1:City
w:st="on"><st1:place w:st="on"><FONT face=Verdana color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">Ardens</SPAN></FONT></st1:place></st1:City><FONT
face=Verdana color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">
Grafton<BR>Alcester<BR>Warwickshire<BR>B49 6DP<BR></SPAN></FONT><FONT
size=2><SPAN style="FONT-SIZE: 10pt"><ns0:place ns1:tabIndex="0"
ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
w:endInsDate="2006-04-26T16:34:00Z" w:endInsAuthor="Chris White"
w:insDate="2006-04-26T16:34:00Z" w:insAuthor="Chris White"><st1:place
w:st="on"><B><FONT face=Verdana color=navy size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">Main</SPAN></FONT></B></st1:place></ns0:place></SPAN></FONT><B><FONT
face=Verdana color=navy size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">:
</SPAN></FONT></B><FONT face=Verdana color=#993300 size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: #993300; FONT-FAMILY: Verdana">+44(0)8451
303040</SPAN></FONT><B><FONT face=Verdana color=#ff9900 size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: #ff9900; FONT-FAMILY: Verdana"><BR></SPAN></FONT></B><B><FONT
face=Verdana color=navy size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Verdana">Fax:</SPAN></FONT></B><B><FONT
face=Verdana color=blue size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: blue; FONT-FAMILY: Verdana">
</SPAN></FONT></B><FONT face=Verdana color=#993300 size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: #993300; FONT-FAMILY: Verdana">+44(0)8451
303141</SPAN></FONT><B><FONT face=Verdana color=#ff9900 size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: #ff9900; FONT-FAMILY: Verdana"><BR></SPAN></FONT></B><SPAN
class=MsoHyperlink><B><FONT face=Verdana color=#333399 size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: #333399; FONT-FAMILY: Verdana; TEXT-DECORATION: none"><A
title="mailto:%20jeremy@keytraffic.com mailto:will@keytraffic.com"
href="mailto:%20chris.white@keytraffic.com"><FONT color=#333399><SPAN
style="COLOR: #333399; TEXT-DECORATION: none"><SPAN
title="mailto:%20jeremy@keytraffic.com mailto:will@keytraffic.com"><SPAN
title=mailto:%20jeremy@keytraffic.com>Mailto:
chris.white@keytraffic.com</SPAN></SPAN></SPAN></FONT></A></SPAN></FONT></B></SPAN><B><U><FONT
face=Verdana color=#333399 size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: #333399; FONT-FAMILY: Verdana"><BR></SPAN></FONT></U></B><B><FONT
face=Verdana color=#333399 size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 7.5pt; COLOR: #333399; FONT-FAMILY: Verdana">Web:
<A title=http://www.keytraffic.com/
href="http://www.keytraffic.com/"><FONT color=#333399><SPAN
style="COLOR: #333399; TEXT-DECORATION: none"><SPAN
title=http://www.keytraffic.com/>www.keytraffic.com</SPAN></SPAN></FONT></A></SPAN></FONT></B><B><FONT
face=Verdana color=navy size=1><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: navy; FONT-FAMILY: Verdana"><o:p></o:p></SPAN></FONT></B></P></TD>
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; WIDTH: 0.9%; PADDING-TOP: 0cm; HEIGHT: 42.75pt"
vAlign=top width=0% height=57>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><FONT
face=Arial color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy; FONT-FAMILY: Arial"> <o:p></o:p></SPAN></FONT></P></TD>
<TD
style="PADDING-RIGHT: 0cm; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; WIDTH: 60.9%; PADDING-TOP: 0cm; HEIGHT: 42.75pt"
vAlign=top width="60%" height=57>
<P class=MsoNormal
style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"><FONT
face=Verdana color=gray size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Verdana">This e-mail
& any attachments are intended only for the use of the person(s) to
whom it is addressed. It may contain information that is privileged and
confidential within the meaning of applicable law. If you are not the
intended recipient, please contact the sender as soon as possible by
return mail or Tel +44 (0) 8451 303040. The views expressed in this
communication may not necessarily be the views held by Key Traffic Systems
Ltd.</SPAN></FONT><o:p></o:p></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV></BODY></HTML>