Infrastructure Map Server Developer

Infrastructure Map Server Developer

Reply
Contributor
matteo.conte
Posts: 20
Registered: ‎05-16-2006
Message 1 of 5 (1,813 Views)

Mapguide 2012, IIS on Win Server 2008 R2 x64

1813 Views, 4 Replies
05-26-2011 05:18 AM

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

Valued Mentor
gluckett
Posts: 384
Registered: ‎10-10-2003
Message 2 of 5 (1,803 Views)

Re: Mapguide 2012, IIS on Win Server 2008 R2 x64

05-27-2011 06:00 PM in reply to: matteo.conte

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


 

Board Manager
Daniel.Du
Posts: 212
Registered: ‎12-23-2008
Message 3 of 5 (1,621 Views)

Re: Mapguide 2012, IIS on Win Server 2008 R2 x64

08-10-2011 03:42 AM in reply to: matteo.conte

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



Daniel Du
Developer Technical Services
Autodesk Developer Network

Valued Contributor
swimming123
Posts: 87
Registered: ‎04-12-2012
Message 4 of 5 (1,253 Views)

Re: Mapguide 2012, IIS on Win Server 2008 R2 x64

04-14-2012 07:57 AM in reply to: Daniel.Du

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

Board Manager
Daniel.Du
Posts: 212
Registered: ‎12-23-2008
Message 5 of 5 (1,248 Views)

Re: Mapguide 2012, IIS on Win Server 2008 R2 x64

04-15-2012 01:16 AM in reply to: matteo.conte

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".



Daniel Du
Developer Technical Services
Autodesk Developer Network

Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.