It is some time since I set up PHP on my Win2k3, it did take me one or two attempts to get it up and running but it is now very stable. If you have any specific problems please let me know and I will try and help out.
I am using PHP 5.1.1
John
-----Original Message----- From: Brennan Stehling [mailto:brennan@offwhite.net] Sent: 04 September 2006 09:41 To: WOODS John Cc: Thomas Bruederli; RoundCube Dev Subject: Re: RC & SQL Server
I have run the MS SQL script on a local copy of SQL Server 2005 SE. It went just fine.
I do not have RC installed on this machine, so is there any other testing I can do?
How painful is it to install PHP onto Windows Server 2003?
Brennan
On Mon, 4 Sep 2006 10:14:48 +0200, "WOODS John" John.Woods@axa-im.com wrote:
Thomas,
Thank you for getting this into the Trunk. I will start testing as
soon
as possible.
On the subject of UTF collation, I will need to look further into
this.
SQL Server does not support UTF but uses the UCS-2 standard for
Unicode
data instead.
The first change would be to change the data types of all the char, varchar and text columns to nchar, nvarchar and ntext to allow Unicode
that's the easy part and we could then leave the collation as it is. I would then have to look at converting the UTF data to UCS-2 with a new function.
I'll let you know how when I have more details.
John
-----Original Message----- From: Thomas Bruederli [mailto:roundcube@gmail.com] Sent: 30 August 2006 18:43 To: WOODS John Cc: RoundCube Dev Subject: Re: RC & SQL Server
Hi John,
Thanks for the code, I just added it to the Trunk. Since I don't have
a
MSSQL server it's up to you to test it.
One final question: Is it possible to use UTF collation instead of Latin1 as you suggested in the mssql.initial.sql file? If yes, what's the exact string for MSSQL?
Regards, Thomas
WOODS John wrote:
Whilst on the subject of different databases some of you may be interested in a port to MS SQL Server that I have made.
[...]
This is a new function that is required to place the *now() *mysql function* *or* getdate() *mssql* *function in SQL query strings. For this to work all occurrences of the string "now()" in the project
have
to be replaced with a call to this function.
Please let me know whether any of you can make use this port.
John Woods
-- Brennan Stehling Offwhite.net LLC brennan@offwhite.net
Try this link it should help. http://www.peterguy.com/php/install_IIS6.html Richard
WOODS John wrote:
It is some time since I set up PHP on my Win2k3, it did take me one or two attempts to get it up and running but it is now very stable. If you have any specific problems please let me know and I will try and help out.
I am using PHP 5.1.1
John
-----Original Message----- From: Brennan Stehling [mailto:brennan@offwhite.net] Sent: 04 September 2006 09:41 To: WOODS John Cc: Thomas Bruederli; RoundCube Dev Subject: Re: RC & SQL Server
I have run the MS SQL script on a local copy of SQL Server 2005 SE. It went just fine.
I do not have RC installed on this machine, so is there any other testing I can do?
How painful is it to install PHP onto Windows Server 2003?
Brennan
On Mon, 4 Sep 2006 10:14:48 +0200, "WOODS John" John.Woods@axa-im.com wrote:
Thomas,
Thank you for getting this into the Trunk. I will start testing as
soon
as possible.
On the subject of UTF collation, I will need to look further into
this.
SQL Server does not support UTF but uses the UCS-2 standard for
Unicode
data instead.
The first change would be to change the data types of all the char, varchar and text columns to nchar, nvarchar and ntext to allow Unicode
that's the easy part and we could then leave the collation as it is. I would then have to look at converting the UTF data to UCS-2 with a new function.
I'll let you know how when I have more details.
John
-----Original Message----- From: Thomas Bruederli [mailto:roundcube@gmail.com] Sent: 30 August 2006 18:43 To: WOODS John Cc: RoundCube Dev Subject: Re: RC & SQL Server
Hi John,
Thanks for the code, I just added it to the Trunk. Since I don't have
a
MSSQL server it's up to you to test it.
One final question: Is it possible to use UTF collation instead of Latin1 as you suggested in the mssql.initial.sql file? If yes, what's the exact string for MSSQL?
Regards, Thomas
WOODS John wrote:
Whilst on the subject of different databases some of you may be interested in a port to MS SQL Server that I have made.
[...]
This is a new function that is required to place the *now() *mysql function* *or* getdate() *mssql* *function in SQL query strings. For this to work all occurrences of the string "now()" in the project
have
to be replaced with a call to this function.
Please let me know whether any of you can make use this port.
John Woods
-- Brennan Stehling Offwhite.net LLC brennan@offwhite.net
-----Original Message----- From: Brennan Stehling [mailto:brennan@offwhite.net] Sent: 04 September 2006 09:41
I have run the MS SQL script on a local copy of SQL Server 2005 SE. It went just fine.
I do not have RC installed on this machine, so is there any other testing I can do?
How painful is it to install PHP onto Windows Server 2003?
Brennan
I use XAMPP and it was no problem to setup on Server 2K3. It'll take some minor .conf fixing to set it to SQL Server rather than MySQL, but it shouldn't be a problem. http://www.apachefriends.org/en/xampp-windows.html
Randy