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?

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.

Dedeffe,

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

Thanks in advance

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';

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.

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.

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

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.