Jump to:

23480 Posts in 18951 Topics by 2878 members

General Questions

SilverStripe Forums » General Questions » External MSSQL database

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 2
Go to End
Author Topic: 3158 Views
  • dendeffe
    Avatar
    Community Member
    135 Posts

    External MSSQL database Link to this post

    I have a client who has data in an external MSSQL database. Has anyone already succesfully done this?
    Running SilverStripe on MySQL and getting some extra data from a MSSQL database?

  • Taffy
    Avatar
    Community Member
    119 Posts

    Re: External MSSQL database Link to this post

    Have a look @ the MSSQL module

    http://silverstripe.org/microsoft-sql-server-database-module/
    http://doc.silverstripe.org/doku.php?id=modules:mssql

    Its not stable and I have not used it so I'm not sure if it'll serve your requirements or not.

  • orion
    Avatar
    Community Member
    20 Posts

    Re: External MSSQL database Link to this post

    Dedeffe,

    Did this work for you? If so can you please show me your method?

    Thanks in advance

  • Willr
    Avatar
    Forum Moderator
    5502 Posts

    Re: External MSSQL database Link to this post

    We have used external MSSQL databases for most of our development. Just need to include the MSSQL server details in your_config file

       global $databaseConfig;
       $databaseConfig['type'] = 'MSSQLDatabase';
       $databaseConfig['server'] = 'server.hostname.com';
       $databaseConfig['username'] = 'username';
       $databaseConfig['password'] = 'password';
       $databaseConfig['database'] = 'SS_dbname';

  • dendeffe
    Avatar
    Community Member
    135 Posts

    Re: External MSSQL database Link to this post

    The project I needed that for didn't end go through in the end. So I don't have any experience with it yet. Good to see that it's working though.

  • orion
    Avatar
    Community Member
    20 Posts

    Re: External MSSQL database Link to this post

    We will be connecting to a mysql database for the silverstripe cms and also to an external ms sql database to retrieve other info. Will I be able to connect to two different databases?

    Than you for your help.

  • ccburns
    Avatar
    Community Member
    74 Posts

    Re: External MSSQL database Link to this post

    Hi Willr,

    Just to clarify, you are saying that you have run the core SilverStripe installation on a MySQL database but been able to connect to an external MSSQL database to pull in new data?

    Just reading this post as well which is suggesting this is more easily possible in 2.4 (which is what I am using).

    http://www.silverstripe.org/data-model-questions/show/273096#post273096

    Thanks in advance for the clarification.

    Cheers,
    Colin

  • Natalia
    Avatar
    Community Member
    1 Post

    Re: External MSSQL database Link to this post

    I'm are trying to setup connection with MS SQL server 2005 as a second database. It works fine on my local Windows machine with WAMP, but on Linux server I get error
    mssql_query(): WARNING! Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?'). (severity 16)
    I've read the suggestions on other forums and recommendation is to setup charset to UTF8.
    On new Silverstirpe download there is line ini_set('mssql.charset', 'utf8'); in MSSQLDatabase.php file. But when I copy this file to the server, I get
    Error 324 (net::ERR_EMPTY_RESPONSE): Unknown error.

    When run database query from php page outside if Silverstripe everything connection works.
    Please help.

    3158 Views
Page: 1 2
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.