Jump to:

22977 Posts in 11742 Topics by 2826 members

General Questions

SilverStripe Forums » General Questions » Access external MSSQL 2008 Server tables

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 1044 Views
  • melman
    Avatar
    Community Member
    3 Posts

    Access external MSSQL 2008 Server tables Link to this post

    Hello, I want to use SilverStripe 2.4 for a new website project. Just a quick question: is it possible to access MSSQL on an external MS Windows 2008 Server from another LAMP-installation? Or do I have to install SilverStripe 2.4 on a Windows 2008 Server with PHP enabled?

  • Willr
    Avatar
    Forum Moderator
    5462 Posts

    Re: Access external MSSQL 2008 Server tables Link to this post

    You can point to an external database server. In fact thats how I run all my mssql projects. When you define your database instead of using localhost simply use the IP or domain of the server you wish to connect to.

  • melman
    Avatar
    Community Member
    3 Posts

    Re: Access external MSSQL 2008 Server tables Link to this post

    Willr,

    Thanks for responding, but I wasn't specific enough.

    This is the case:

    Silverstripe 2.4 installed on Linux-server with MySQL. My client has database tables in another external MS SQL Server 2008 which have to be read in in het LAMP-hosted SilverStripe site. What's the correct way to read in those external MS-databases in the SilverStripe website? Where do I have to configure this and how can this be done?

  • melman
    Avatar
    Community Member
    3 Posts

    Re: Access external MSSQL 2008 Server tables Link to this post

    Please, is here anyone on this forum with some detailed info about:

    - installing Silverstripe 2.4 on Linux/Apache/MySQL/PHP5
    - import data from external MS SQL databases on another server?

    1044 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.