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?
We've moved the forum!
Please use forum.silverstripe.org for any new questions
(announcement).
The forum archive will stick around, but will be read only.
You can also use our Slack channel
or StackOverflow to ask for help.
Check out our community overview for more options to contribute.
- Page 11(current)
- 2
- Next 10 entries
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.
- Page 11(current)
- 2
- Next 10 entries