• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    Autodesk MapGuide Enterprise Developer

    Reply
    Contributor
    Posts: 17
    Registered: ‎05-16-2006

    Mapguide 2012, IIS on Win Server 2008 R2 x64

    1544 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

    Please use plain text.
    Mentor
    Posts: 249
    Registered: ‎10-10-2003

    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


     

    Please use plain text.
    ADN Support Specialist
    Posts: 103
    Registered: ‎12-23-2008

    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

    Please use plain text.
    Valued Contributor
    Posts: 72
    Registered: ‎04-12-2012

    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.

    Please use plain text.
    ADN Support Specialist
    Posts: 103
    Registered: ‎12-23-2008

    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

    Please use plain text.