Crystal was pulling the data through MyODBC, Mascon was just used for inserting the image into the database.
hth danny On Thu, 2003-10-09 at 16:20, Director General: NEFACOMP wrote: > 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]
