Mapguide 2012, IIS on Win Server 2008 R2 x64

[ced_abitat]

Hi all,

  I have install Infrastructure MapServer 2012 (64 bit) on Windows Server 2008 R2 64 bit. I have choose IIS as Web Server and PHP as API.

I wuold like to connect with Microsoft SQL Server 2008 but on PHP extension there isn't any extension for MSSQL. I read that PHP 5.3 don't have native extension for MSSQL. So I download Sql Server driver for PHP 2.0 and add extension on PHP.INI.

Now when I start a phpinfo page I get a error on php-cgi.exe: The FastCGI process exited unexpectedly. The error code is 0x000000ff

Can you help me?

Regards

Matteo

[gluckett]

Just use ADO

  $connstr="PROVIDER=SQLOLEDB;SERVER=localhost\\SQLEXPRESS;UID=sa;PWD=password;DATABASE=MAIN;

$conn = new COM("ADODB.Connection",NULL,1252);

 $conn->Open($connstr);

this works with IIS and Windows Server 2008 R2.

gordon

[Daniel.Du]

You can use OSGeo FDO provide for SQL Server Spatial, which is a buit-in provider of Infrastructure Map Server 2012.

[swimming123]

How can I connect to PostGIS for Autodesk Infrastructure Map Server2012? Thank you.

[Daniel.Du]

OSGeo FDO Provider for Postgre/SQL/PostGIS is one of built-in providers, you can connect to PostGIS with this provider in Infrastructure Studio by adding a new "Data Connection".