Help mantis with sql server
Posted: 20 Sep 2005, 12:15
Helo
i try to use mantis with sqlserver.
I create the script mssql with install.php file
i have connected mantis to sql server with odbc
But now i have a problem when i am connected :
Database query failed. Error received from database was #22008: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. for the query: UPDATE mantis_user_table
SET last_visit= '2005-09-20 01:51:09PM'
WHERE id='1'
the datetime format of request is not ok for mysql server (normaly i should use the fuiunction convert)
Can you help me
Can you tell me all i must do for use mantis with sql server without error message.
With file i must modify?
Do i modify all request of mantis ?
the version i use is 1.0.0r2c
thank you
i try to use mantis with sqlserver.
I create the script mssql with install.php file
i have connected mantis to sql server with odbc
But now i have a problem when i am connected :
Database query failed. Error received from database was #22008: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. for the query: UPDATE mantis_user_table
SET last_visit= '2005-09-20 01:51:09PM'
WHERE id='1'
the datetime format of request is not ok for mysql server (normaly i should use the fuiunction convert)
Can you help me
Can you tell me all i must do for use mantis with sql server without error message.
With file i must modify?
Do i modify all request of mantis ?
the version i use is 1.0.0r2c
thank you