<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Where to Next?</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=936290508-17102007><FONT face=Arial
color=#0000ff size=2>Is the OGR provider an option for rendering ODBC layers? I
see it does support ODBC, but it's unclear how it will deal with a non-spatial
layer, form which I want to map point features.</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> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Campbell,
Keith A<BR><B>Sent:</B> 16 October 2007 15:13<BR><B>To:</B> MapGuide Users Mail
List<BR><B>Subject:</B> [mapguide-users] Where to Next?<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format --><BR>
<P><FONT face=Arial size=2>I've run out of ideas and need some guidance on how
to resolve this.</FONT> </P>
<P><FONT face=Arial size=2>Problem:</FONT> <BR><FONT face=Arial size=2>I have a
point layer based on an ODBC connection to a SQL Server 2000 database that works
on a UAT server.</FONT> <BR><FONT face=Arial size=2>When packaged up and loaded
onto a production server, no data displays for the layer when the layout
containing it is viewed in the ajax viewer. No error is returned.</FONT></P>
<P><FONT face=Arial size=2>The DSNs on UAT and Production both use the SQL
Server driver, have the same name, and the database credentials and structure
are the same. There is data in the Production database.</FONT></P>
<P><FONT face=Arial size=2>I have another point layer based on a table in
another database on the same instance of SQL Server on the production server
that works.</FONT></P>
<P><FONT face=Arial size=2>I cannot check the data source, etc using Studio as
Studio will not connect to the production server ('Unexpected error contacting
site URL').</FONT></P>
<P><FONT face=Arial size=2>MapGuide 6.3 will read the data for the problem layer
using the DSN on the production server.</FONT> </P>
<P><FONT face=Arial size=2>Any ideas?</FONT> </P>
<P><FONT face=Arial size=2>Keith</FONT> </P><BR><BR>
<CENTER><FONT face="Arial, Helvetica, sans-serif" size=2><B>This email and any
attached files are confidential and copyright protected. If you are not the
addressee, any dissemination of this communication is strictly prohibited.
Unless otherwise expressly agreed in writing, nothing stated in this
communication shall be legally binding.</B></FONT>
<P><FONT face="Arial, Helvetica, sans-serif" size=2>The ultimate parent company
of the Atkins Group is WS Atkins plc. Registered in England No. 1885586.
Registered Office Woodcote Grove, Ashley Road, Epsom, Surrey KT18 5BW.</FONT>
<P><FONT face=Webdings color=green size=5>P</FONT> <FONT
face="Arial, Helvetica, sans-serif" color=green size=2><B>Consider the
environment. Please don't print this e-mail unless you really need
to.</B></FONT> </CENTER></P><BR><BR>
<P align=center><FONT face="Arial, Helvetica, sans-serif" color=#000000
size=2>This message has been scanned for viruses by </FONT><A
href="http://bluepages.wsatkins.co.uk/?6875772"><FONT
face="Arial, Helvetica, sans-serif" color=#000000
size=2>MailControl</FONT></A></P></BODY></HTML>