I want to ask you one thing: Is your Crystal Report accessing the database through the Mascon Utility or it uses MyODBC?
I think the main problem to me is how Crystal Report is accessing the database. I will try to access the database using ADO and see if there is any change. Thanks Emery ----- Original Message ----- From: "Danny Haworth" <[EMAIL PROTECTED]> To: "Director General: NEFACOMP" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 14:41 Subject: Re: BLOB images in Crystal Reports > I've had no problems with MySQL, crystal reports and blob images. Main > differences here are the following: > > Crystal Reports 8.5 (not 7) > Myodbc 2.x (haven't tried 3.x yet with images) > > Images were also inserted into the MySQL database using a third party > utility called Mascon (http://www.scibit.com/). They do a free, > unlimited, version (annoying nag screens but still) if you want to try > that out? If that works, you can see the differences between the way > mascon stores them, and the way you are storing them.. > > I'm assuming if crystal is reading happily from mssql then that cant be > at fault. > > hth > > danny > > On Thu, 2003-10-09 at 13:08, Director General: NEFACOMP wrote: > > It was a good idea but it is not feasible for my case since I will be > > displaying many images coming in a recordset with many records. If it was > > only one record, then I would follow your advice. > > > > When I get the images from a MS SQL 2000, Crystal Reports displays them > > without problems. But when I switch to MySQL, I fail. > > > > > > Thanks > > Emery > > ----- Original Message ----- > > From: "DenBaguse MasRodjie" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]>; "Director General: NEFACOMP" <[EMAIL PROTECTED]> > > Sent: Thursday, October 09, 2003 12:44 > > Subject: Re: BLOB images in Crystal Reports > > > > > > > You can manually get that BLOB binaries from MySQL and copied to local > > file. > > > And from CR get that file. > > > > > > > > > Rgds, > > > > > > > > > Roji > > > > > > ----- Original Message ----- > > > From: "Director General: NEFACOMP" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Cc: "Mike Hillyer" <[EMAIL PROTECTED]> > > > Sent: Thursday, October 09, 2003 4:23 PM > > > Subject: BLOB images in Crystal Reports > > > > > > > > > Hi group, > > > > > > has anyone tried to display BLOB pictures from MySQL through MyODBC in > > > Crystal Reports? > > > I have tried everything but I failed. > > > > > > > > > Any ideas on how to achieve this is highly appreciated. > > > I am using: > > > MySQL 4.1.0 or MySQL 4.0.14 > > > MyODBC 3.51.06 > > > Crystal Reports Ver 7 (7.0.1.192) > > > > > > > > > Thanks, > > > __________________________________ > > > NZEYIMANA Emery Fabrice > > > NEFA Computing Services, Inc. > > > P.O. Box 5078 Kigali > > > Office Phone: +250-51 11 06 > > > Office Fax: +250-50 15 19 > > > Mobile: +250-08517768 > > > Email: [EMAIL PROTECTED] > > > http://www.nefacomp.net/ > > > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]