Error added: 2010-01-12 12:12
Steps to Reproduce:
1. Use the default configuration of PHP with the mssql-extension.
2. create a sql-statement that selects a smalldatetimevalue from a
MSSQL-Database or use the Script at the end of this report.
3. the Script dies in the mssql_query()-function
Solution:
I found the following solution that works for me:
1. Open php.ini
2. "Decomment" the line "mssql.datetimeconvert = On" and change it to
"mssql.datetimeconvert = Off"
3. Restart Apache
4. The Problem dissappears
If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.
If you want to be notified via email when this is solved, enter your email address here:
Hosted on a linuxvps.org Linux Virtual Private Server. Why not get your own?