Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Ocke Janssen
Moin, I just have to set the issue to wontfix. :-( The problem seems to be the database. Even with odbctest I get the same results = error and I tested a StarOffice 9.2 which is equal to OOo 3.2, same error as in OOo 3.2.1 and 3.3. Did anyone did an upgrade to a newer MySQL version before

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Alex Thurgood
Hi Ocke, - Ocke Janssen ocke.jans...@oracle.com a écrit : I just have to set the issue to wontfix. :-( The problem seems to be the database. Even with odbctest I get the same results = error and I tested a StarOffice 9.2 which is equal to OOo 3.2, same error as in OOo 3.2.1 and 3.3.

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Ocke Janssen
Hi Alex, First of all if I could I would like to fix it. On 09.12.2010 09:34, Alex Thurgood wrote: Hi Ocke, - Ocke Janssenocke.jans...@oracle.com a écrit : I just have to set the issue to wontfix. :-( The problem seems to be the database. Even with odbctest I get the same results =

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Alex Thurgood
Hi Ocke, - Ocke Janssen ocke.jans...@oracle.com a écrit : As I mentioned, CAST works for me with OOo 3.2.1. It also works for me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that is based on). One more interesting thing when executing select CAST('2001-01-01' as

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Ocke Janssen
Hi Alex, On 09.12.2010 10:35, Alex Thurgood wrote: Hi Ocke, - Ocke Janssenocke.jans...@oracle.com a écrit : As I mentioned, CAST works for me with OOo 3.2.1. It also works for me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that is based on). One more interesting

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Fernand Vanrie
Ocke, It has certainly nothing to sea with the SQL version or server type. I work in a company envoriment, everyone uses the same SQL server, same native OO-connector. Everyone works on OO 3.2 without problems, i test 3.3 and have the CAST problem: cast(`mag_news_export`.`DATUM` as date) AS

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Ocke Janssen
Hi Fernand, On 09.12.2010 15:28, Fernand Vanrie wrote: Ocke, It has certainly nothing to sea with the SQL version or server type. I work in a company envoriment, everyone uses the same SQL server, same native OO-connector. Everyone works on OO 3.2 without problems, i test 3.3 and have the CAST

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Fernand Vanrie
Ocke, I was just wondering, my problems with CAST started (i think) after i instaled the very latest (oracle-report-builder-OOO330-m3.oxt)for testing . Now i tried to remove this ORB version but i get a error so i can not test without ORB loaded. just a hint PS. how do i remove this

Re: [dba-dev] Re: CAST() no longer working with OOO 330m16

2010-12-09 Thread Fernand Vanrie
Ocke, sorry in my code no space , then i typed cast in uppercase(CAST), no difference.. cast(`mag_news_export`.`DATUM` as date) AS `DATUM`, On 09.12.2010 15:28, Fernand Vanrie wrote: Ocke, It has certainly nothing to sea with the SQL version or server type. I work in a company