SQL Problem

SQL Problem

am 11.07.2003 13:23:27 von Henry Jones

------_=_NextPart_000_01C3479E.D981C070
Content-Type: text/plain

I am having problems using Crystal Reports to report on the RT (Request
Tracker) database which is a MySQL Database.

I am using Crystal Reports 8.0.1.0
RT Version 1.0.6
MySQL ODBC Driver 3.51
MySQL 3.23.54

We have some reports which have been running for some time on a machine
using a User DSN under Windows 2000.
I now want to run them on my machine (Windows XP) but I get an error
<>
I have tried using both User and File DSNs but always get the same result. I
have tried on Windows 2000 laptop similar to the one it used to be run on
with the same result. I have also tried it on a Windows NT machine. Always I
get the same result.

Another colleagues working on the same NT machine with an identical User DSN
can get it to run. He can even run it using a file DSN.
He has tried on my machine but it gives the same error message.

I have looked at the SQL Code after it fails for me and when it works and it
is different. The good code is
<>
The bad code is
<>
I also enclose a copy of the report in case that helps.
<

Is there a place on the web to see the ETA on new production releases?

am 11.07.2003 22:48:06 von Adam Pedersen

That pretty much says it all. I'm waiting for 4.0.14



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: SQL Problem

am 12.07.2003 02:21:37 von Venu

On Fri, 2003-07-11 at 04:23, Henry Jones wrote:

Hi !!

> I am having problems using Crystal Reports to report on the RT (Request
> Tracker) database which is a MySQL Database.
>
> I am using Crystal Reports 8.0.1.0
> RT Version 1.0.6
> MySQL ODBC Driver 3.51
> MySQL 3.23.54
>

Looks like the error image is filtered by the list, so couldn't help
you.

The best way is to file a bug report in bugs.mysql.com with related
attachments, so that we can comment further.

Also provide the following information:

MDAC version on working and non-working systems.

Thanks

> We have some reports which have been running for some time on a machine
> using a User DSN under Windows 2000.
> I now want to run them on my machine (Windows XP) but I get an error
> <>
> I have tried using both User and File DSNs but always get the same result. I
> have tried on Windows 2000 laptop similar to the one it used to be run on
> with the same result. I have also tried it on a Windows NT machine. Always I
> get the same result.
>
> Another colleagues working on the same NT machine with an identical User DSN
> can get it to run. He can even run it using a file DSN.
> He has tried on my machine but it gives the same error message.
>
> I have looked at the SQL Code after it fails for me and when it works and it
> is different. The good code is
> <>
> The bad code is
> <>
> I also enclose a copy of the report in case that helps.
> <

Re: Is there a place on the web to see the ETA on new production releases?

am 12.07.2003 09:43:30 von Sergei Golubchik

Hi!

On Jul 11, Adam Pedersen wrote:
> That pretty much says it all. I'm waiting for 4.0.14

No.

and -

It's being built right now.
Probles with some platforms (like AIX and HPUX) may delay release a bit,
but it should be out next week. Unless there will be a critical bug
found, of course.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org