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
mantis and sql server
Moderators: Developer, Contributor
-
Guest
I can't give you specifics on 1.0.0r2c, but I am successfully using SQL Server 2000 with Mantis 1.0.0a3.
To do so, I ended up having to manually build the database (the script didn't work) and go through the error messages one by one. There are were also PHP changes. It took a few days to get everything shaken out, but now it works well. Just tackle the errors one at a time and you will get there.
To do so, I ended up having to manually build the database (the script didn't work) and go through the error messages one by one. There are were also PHP changes. It took a few days to get everything shaken out, but now it works well. Just tackle the errors one at a time and you will get there.
-
Guest
Please, give us your creation script !
Anonymous wrote:I can't give you specifics on 1.0.0r2c, but I am successfully using SQL Server 2000 with Mantis 1.0.0a3.
To do so, I ended up having to manually build the database (the script didn't work) and go through the error messages one by one. There are were also PHP changes. It took a few days to get everything shaken out, but now it works well. Just tackle the errors one at a time and you will get there.