4649 Posts in 1402 Topics by 1394 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1537 Views |
-
Problems with MSSQL installation
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_ASAny 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.
-
Re: Problems with MSSQL installation
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 utf8SS is gonna work much better that way... and so will everything else ;)
-
Re: Problems with MSSQL installation
17 June 2010 at 1:02am
Try using the SQL Server Driver for PHP provided by Microsoft.
| 1537 Views | ||
|
Page:
1
|
Go to Top |
