<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>Where to Next?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<P><FONT SIZE=2 FACE="Arial">I've run out of ideas and need some guidance on how to resolve this.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Problem:</FONT>
<BR><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">MapGuide 6.3 will read the data for the problem layer using the DSN on the production server.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Any ideas?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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>
</body>
</HTML>