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