Jump to:

4935 Posts in 16178 Topics by 1488 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Problems with MSSQL installation

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

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

Page: 1
Go to End
Author Topic: 1809 Views
  • trailmax
    Avatar
    Community Member
    2 Posts

    Problems with MSSQL installation Link to this post

    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.

  • SlothMaster456
    Avatar
    Community Member
    3 Posts

    Re: Problems with MSSQL installation Link to this post

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

  • trailmax
    Avatar
    Community Member
    2 Posts

    Re: Problems with MSSQL installation Link to this post

    funny, haha

  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: Problems with MSSQL installation Link to this post

    Try using the SQL Server Driver for PHP provided by Microsoft.

    1809 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.