<br><font size=2 face="sans-serif">Just wondering if there is any progress/ideas
on this and whether I need to report it as a bug somewhere? Again,
it seems that the ODBC FDO provider connection to SQL Server is timing
out and it throws an error instead of reconnecting. </font>
<br>
<br><font size=2 face="sans-serif">Thanks for all your help... </font>
<br>
<br><font size=2 face="sans-serif">Ian Elsinga</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Dave Wilson"
<dave.wilson@autodesk.com></b> </font>
<br><font size=1 face="sans-serif">Sent by: mapguide-users-bounces@lists.osgeo.org</font>
<p><font size=1 face="sans-serif">07/05/2007 11:36 AM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
MapGuide Users Mail List <mapguide-users@lists.osgeo.org></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td valign=top><font size=1 face="sans-serif">"MapGuide Users Mail
List" <mapguide-users@lists.osgeo.org></font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">RE: [mapguide-users] ODBC
Point features failure</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2 color=#1f497d face="Calibri">Are there any errors logged
in the server error log? It seems to me something is causing the provider
to die? Usually there is at least 1 error logged before something like
this can happen.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">What coordinate system is
your data in and what coordinate system is your map in?</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">Have you tried using the
DWF Viewer/Autodesk Design Review? I’m curious if it’s the data or something
in the viewer behavior.</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 color=#1f497d face="Calibri">Regards,</font>
<br><font size=2 color=#1f497d face="Calibri">Dave</font>
<br><font size=2 color=#1f497d face="Calibri"> </font>
<br><font size=2 face="Tahoma"><b>From:</b> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>IElsinga@fac.bm<b><br>
Sent:</b> Thursday, July 05, 2007 6:25 AM<b><br>
To:</b> MapGuide Users Mail List<b><br>
Cc:</b> MapGuide Users Mail List; mapguide-users-bounces@lists.osgeo.org<b><br>
Subject:</b> RE: [mapguide-users] ODBC Point features failure</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=2 face="Arial"><br>
I noticed that when it stops working, there are no more SQL statements
being sent to the database. (Discovered by using SQL Profiler). </font><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
Ian Elsinga<br>
Senior Client/Server Application Developer<br>
First Atlantic Commerce<br>
Bermuda<br>
<br>
mailto:ielsinga@fac.bm<br>
Phone : (441) 294-4640<br>
Primary Fax : (441) 295-6855 <br>
Secondary Fax : (441) 295-6708<br>
<br>
http://www.firstatlanticcommerce.com<br>
<br>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
The information in this Internet e-mail, including attachments, contains
information that is confidential and may be protected by attorney client
privileges. This email, including attachments, constitutes non-public information
intended only for the use of the designated recipient(s) to which it is
addressed and may contain legal or financial information which is privileged,
confidential or subject to copyright. Access by any other person to this
Internet e-mail is not authorized. If you are not the intended recipient,
please delete this Internet e-mail, including attachments, immediately
and notify the sender by return email. Any disclosure of this Internet
e-mail, including attachments, or of the parties to it, or copying, distribution
or any action taken or omitted to be taken in reliance on it is prohibited,
and may be unlawful.</font><font size=3 face="Times New Roman"><br>
<br>
</font>
<p>
<table width=100%>
<tr valign=top>
<td width=47%><font size=1 face="Arial"><b>IElsinga@fac.bm</b> <br>
Sent by: mapguide-users-bounces@lists.osgeo.org</font><font size=3 face="Times New Roman">
</font>
<p><font size=1 face="Arial">07/05/2007 09:15 AM</font><font size=3 face="Times New Roman">
</font>
<p>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="Arial">Please respond to<br>
MapGuide Users Mail List <mapguide-users@lists.osgeo.org></font></div></table>
<br>
<td width=52%>
<br>
<table width=100%>
<tr>
<td width=12%>
<div align=right><font size=1 face="Arial">To</font></div>
<td width=87% valign=top><font size=1 face="Arial">MapGuide Users Mail
List <mapguide-users@lists.osgeo.org></font><font size=3 face="Times New Roman">
</font>
<tr>
<td>
<div align=right><font size=1 face="Arial">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="Arial">Subject</font></div>
<td valign=top><font size=1 face="Arial">RE: [mapguide-users] ODBC Point
features failure</font></table>
<br><font size=3 face="Times New Roman"> </font>
<p>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=49%></table>
<br></table>
<br><font size=3 face="Times New Roman"><br>
<br>
</font><font size=2 face="Arial"><br>
<br>
Thanks for the response - there is 4GB of RAM on the mapguide server which
is running Windows Server 2003. There are no properties selected
and there are only two layers. It is pulling data via ODBC from
SQL Server on another server which is configured similarly. </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
I can use the map for a few minutes, zooming, panning, clicking on points,
etc., but then the points disappear for no reason and the only way I can
get them back is to restart the mapguide service. </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
Is this a bug I should report somewhere? <br>
<br>
Thanks, <br>
<br>
Ian Elsinga<br>
Senior Client/Server Application Developer<br>
First Atlantic Commerce<br>
Bermuda<br>
<br>
mailto:ielsinga@fac.bm<br>
Phone : (441) 294-4640<br>
Primary Fax : (441) 295-6855 <br>
Secondary Fax : (441) 295-6708<br>
<br>
http://www.firstatlanticcommerce.com<br>
<br>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
The information in this Internet e-mail, including attachments, contains
information that is confidential and may be protected by attorney client
privileges. This email, including attachments, constitutes non-public information
intended only for the use of the designated recipient(s) to which it is
addressed and may contain legal or financial information which is privileged,
confidential or subject to copyright. Access by any other person to this
Internet e-mail is not authorized. If you are not the intended recipient,
please delete this Internet e-mail, including attachments, immediately
and notify the sender by return email. Any disclosure of this Internet
e-mail, including attachments, or of the parties to it, or copying, distribution
or any action taken or omitted to be taken in reliance on it is prohibited,
and may be unlawful.</font><font size=3 face="Times New Roman"><br>
</font>
<p>
<table width=100%>
<tr valign=top>
<td width=47%><font size=1 face="Arial"><b>"Dave Wilson" <dave.wilson@autodesk.com></b>
<br>
Sent by: mapguide-users-bounces@lists.osgeo.org</font><font size=3 face="Times New Roman">
</font>
<p><font size=1 face="Arial">07/04/2007 06:47 PM</font><font size=3 face="Times New Roman">
</font>
<p>
<br>
<table border=4 width=100%>
<tr valign=top>
<td width=100% bgcolor=white>
<div align=center><font size=1 face="Arial">Please respond to<br>
MapGuide Users Mail List <mapguide-users@lists.osgeo.org></font></div></table>
<br>
<td width=52%>
<br>
<table width=100%>
<tr>
<td width=12%>
<div align=right><font size=1 face="Arial">To</font></div>
<td width=87% valign=top><font size=1 face="Arial">"MapGuide Users
Mail List" <mapguide-users@lists.osgeo.org></font><font size=3 face="Times New Roman">
</font>
<tr>
<td>
<div align=right><font size=1 face="Arial">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="Arial">Subject</font></div>
<td valign=top><font size=1 face="Arial">RE: [mapguide-users] ODBC Point
features failure</font></table>
<br><font size=3 face="Times New Roman"> </font>
<p>
<br>
<table width=100%>
<tr valign=top>
<td width=50%>
<td width=49%></table>
<br></table>
<br><font size=3 face="Times New Roman"><br>
<br>
</font><font size=2 color=#1f497d face="Calibri"><br>
<br>
In house testing with a feature source containing almost 10,000 features
appears to work fine.</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 color=#1f497d face="Calibri"><br>
How much memory on your system? What is the OS? Do you have properties
selected on your layer? How many other layers are in your map?</font><font size=3 face="Times New Roman">
<br>
</font><font size=2 color=#1f497d face="Calibri"><br>
Regards,</font><font size=3 face="Times New Roman"> </font><font size=2 color=#1f497d face="Calibri"><br>
Dave</font><font size=3 face="Times New Roman"> <br>
</font><font size=2 face="Tahoma"><b><br>
From:</b> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org]
<b>On Behalf Of </b>IElsinga@fac.bm<b><br>
Sent:</b> Wednesday, July 04, 2007 10:33 AM<b><br>
To:</b> mapguide-users@lists.osgeo.org<b><br>
Subject:</b> [mapguide-users] ODBC Point features failure</font><font size=3 face="Times New Roman">
<br>
</font><font size=2 face="Arial"><br>
<br>
I am using MGOS 1.2 RC2 and am experiencing a problem with an ODBC connected
to SQL Server point source. Points are displayed initially,
but then eventually they are not displayed any longer. Opening a
new web browser does not help. The only way I can get them to come
back is to restart the MapGuide windows service - then the points will
come back - for a few minutes of interaction. </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
I am bringing back 1000 points from a SQL Server database. This
behaviour was the same in 1.2 RC1. <br>
<br>
This will obviously make mapguide unusable for our purposes - is there
a problem with the ODBC FDO? </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
I will be grateful for any assistance! </font><font size=3 face="Times New Roman">
</font><font size=2 face="Arial"><br>
<br>
<br>
Ian Elsinga</font><font size=2 face="Courier New">_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapguide-users<br>
_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapguide-users</font><font size=2><tt>_______________________________________________<br>
mapguide-users mailing list<br>
mapguide-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapguide-users<br>
</tt></font>
<br>