Infrastructure Map Server Developer

Infrastructure Map Server Developer

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

Mapguide 2012, IIS on Win Server 2008 R2 x64

1825 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: 391
Registered: ‎10-10-2003
Message 2 of 5 (1,815 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: 215
Registered: ‎12-23-2008
Message 3 of 5 (1,633 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,265 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: 215
Registered: ‎12-23-2008
Message 5 of 5 (1,260 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
Need installation help?

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