error 500 on SQL Server means the actual DB connection wasn't made (or lost), or timed out<div><br></div><div>so you might be looking more at your connection settings and ensure those channels are valid etc.</div><div>
or perform simple tests on a super small table..</div><div><br></div><div>like...</div><div><br></div><div>select * from Table1 where ID<5<br><br>just to ensure you get your connection up and working right</div><div><br>
</div><div><br><div class="gmail_quote">On Tue, Sep 11, 2012 at 3:24 PM, elliott17 <span dir="ltr"><<a href="mailto:elliottd@ae.ca" target="_blank">elliottd@ae.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I am running php 5.4.6 on Server 2008 with MGOS 2.2 and SQL server 2008 r2.<br>
<br>
I have set up a php page to call an image for the Fusion map tip and keep<br>
getting an error (500 internal server error). I created an identical php<br>
file on the server and it works. My post message is "Test Test!!<br>
../images/Walls/Mariner Way/sw10/P1020533.JPG Image ID: 25 "<br>
<br>
Is there a setting that I am missing to have this work?<br>
<br>
My php file is:<br>
<br>
<html xmlns="<a href="http://www.w3.org/1999/xhtml" target="_blank">http://www.w3.org/1999/xhtml</a>"><br>
<br>
<head><br>
<HEAD><br>
<br>
<title>Gregs Test</title><br>
<br>
</head><br>
<body><br>
Test Test!!<br>
<br>
<?php<br>
<br>
$oid = $_GET["ImageID"];<br>
<br>
$serverName = "XXXXXX\sqlexpress";<br>
<br>
$connectionInfo = array( "Database"=>"database name", "UID"=>"Username to<br>
SQL", "PWD"=>"pwd to SQL");<br>
<br>
$conn = sqlsrv_connect($serverName, $connectionInfo);<br>
<br>
if(!$conn)<br>
{<br>
echo "<br/>Couldn't connect to SQL Server on $serverName";<br>
}<br>
<br>
$result = sqlsrv_query( $conn, 'select URL from wall_lines where OID = (?)<br>
', array( $oid ));<br>
<br>
while($row = sqlsrv_fetch_array($result))<br>
{<br>
echo($row['URL']);<br>
}<br>
<br>
echo "Image ID: " . $oid;<br>
<br>
?><br>
<br>
</body><br>
</html><br>
<br>
Thanks.<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1560.n6.nabble.com/How-to-get-selected-feature-information-in-popup-window-tp4999139p5001157.html" target="_blank">http://osgeo-org.1560.n6.nabble.com/How-to-get-selected-feature-information-in-popup-window-tp4999139p5001157.html</a><br>
<div class="HOEnZb"><div class="h5">Sent from the MapGuide Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></div></blockquote></div><br></div>