Infrastructure Map Server Developer

Infrastructure Map Server Developer

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

Mapguide 2012, IIS on Win Server 2008 R2 x64

1844 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: 426
Registered: ‎10-10-2003
Message 2 of 5 (1,834 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


 

ADN Support Specialist
Daniel.Du
Posts: 270
Registered: ‎12-23-2008
Message 3 of 5 (1,652 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,284 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.

ADN Support Specialist
Daniel.Du
Posts: 270
Registered: ‎12-23-2008
Message 5 of 5 (1,279 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

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.