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

1851 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
Announcements
Are you interested in helping shape the future of the Autodesk Community? To participate in this brief usability study, please click here. Your time and input is greatly appreciated!