Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

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

Problems with MSSQL installation


Reply


4 Posts   1857 Views

Avatar
trailmax

Community Member, 2 Posts

12 June 2010 at 4:29am

Hi there

Trying out Silver Stripe, see if it fits our requirements for the next project.

Tried to install it today, but I get error message from database just on the second screen of installation

[Warning] mssql_query() [function.mssql-query]: message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16)

POST /recruitment/install.php

Tried to google the problem, but no feasible solutions so far. Some people did recommend changing the datatypes in DB columns, some changing SQL queries. None are suitable for fresh installation of the CMS. I might think we need to tune in database encoding (set as what?)

I wonder if something wrong with our server setup or database setup:
Windows 2003
IIS 6.0
MSSQL Server 2005
PHP 5.2 build 3790
MSSQL library version 7.0
Database collation is Latin1_General_CI_AS

Any idea/pointer where I should dig?
I'll appreciate any help!

Thanks

p.s. Please don't suggest updating to IIS 7 or MSSQL 2008 - we are stuck with this versions, as our other major system does not work with higher versions of this servers. However, we can update php and libraries.

Avatar
SlothMaster456

Community Member, 3 Posts

16 June 2010 at 3:01am

lol, I see something wrong with your server setup. Try changing to:

Ubuntu Linux 8.04 lts
Apache
MySQL
PHP 5.26
Database collation is utf8

SS is gonna work much better that way... and so will everything else ;)

Avatar
trailmax

Community Member, 2 Posts

16 June 2010 at 3:33am

funny, haha

Avatar
Sean

Forum Moderator, 922 Posts

17 June 2010 at 1:02am

Try using the [url=http://sqlsrvphp.codeplex.com/]SQL Server Driver for PHP[/url] provided by Microsoft.