Infrastructure Map Server Developer

Infrastructure Map Server Developer

Reply
Contributor
21 Posts
0 Kudos
Registered: ‎05-16-2006
Post 1 of 5

Mapguide 2012, IIS on Win Server 2008 R2 x64

1849 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
434 Posts
74 Kudos
Registered: ‎10-10-2003
Post 2 of 5

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
294 Posts
17 Kudos
Registered: ‎12-23-2008
Post 3 of 5

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
88 Posts
1 Kudo
Registered: ‎04-12-2012
Post 4 of 5

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
294 Posts
17 Kudos
Registered: ‎12-23-2008
Post 5 of 5

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