Re: ASPJpeg

Hi Shahid M. Syed,

On Wed, 31 Dec 2003, Shahid M. Syed wrote:
> I have Office 2002 installed on Win XP Pro, but the Access database which I
> am using with ASPJpeg is in 2000 file format.
> you wrote: "I was not able to duplicate your problem with what I tried." I
> didn't get it. Are you having problems with Access too?
> By the way I am using ASPJpeg in an ASP page not VB.

I did not use ASPJpeg.  I did not have a problem with what I tried, but my
Blob was << 15 MB.  There is a bug that I have duplicated, but have not
fixed it yet with MyODBC 3.51.06 and Blobs >> 16 MB.  It is on my todo
list. So the question is are your Blobs >> 16 MB if yes than this is a bug
and I will working on it soon and fixing it.

Some version of Access have in the Options dialogue box of the Tables /
Queries tab.  At the bottom on the right is an option for making the SQL
statements compatible with ANSI 92 for the current DB.  This also can
cause problems.


> ----- Original Message -----
> From: "Boyd Gerber" <[email protected]>
> To: "Shahid M. Syed" <[email protected]>
> Cc: <[email protected]>
> Sent: Tuesday, December 30, 2003 6:13 AM
> Subject: Re: ASPJpeg
>
>
> > Hi Shahid M. Syed,
> > On Tue, 30 Dec 2003, Shahid M. Syed wrote:
> > > Hello,
> > > I sent the following email to ASPJpeg support:
> > >
> >
> > Could you please provide the version of access you are using.  I was not
> > able to duplicate your problem with what I tried.  I use w2k and the
> > access that comes with Office Pro 2000.
> >
> > Sincerely,
> >
> > --
> > Boyd Gerber, Software Engineer & Support Specialist
> > MySQL AB, www.mysql.com
> >
> > Are you MySQL certified?  www.mysql.com/certification
> >
> >
> > --------------------------------------------------------------------------
> ------
> > >
> > >
> > > AspJpeg is running fine with Access database. Using AspJpeg to save
> > > images in MySQL database is also working, but when I try to read an
> > > image from MySQL database I get following error.
> > >
> > > Error Type:
> > > Persits.Jpeg.1 (0x8004003D)
> > > Invalid JPEG file structure: two SOI markers
> > > /view.asp, line 15
> > >
> > > line 15: Jpeg.OpenBinary rs("image").Value
> > >
> > > Field "image" is a BLOB. Access database via ODBC is also working
> > > fine.
> > >
> > > System Info:
> > >
> > > Browser Type:
> > > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)
> > >
> > > MySQL 4.0.17
> > > MyODBC 3.51
> > >
> > > Is there any way I can make it work with MySQL database?
> > >
> > >
> >
> > --------------------------------------------------------------------------
> ------
> > >
> > > And I got the following response:
> > >
> > >
> >
> > --------------------------------------------------------------------------
> ------
> > >
> > > I'm afraid that's an error we haven't seen before, and we don't have
> > > MySQL here ourselves to test.  If it works in Access, then the problem
> > > is with MySQL or its interface somehow, but I'm afraid we really don't
> > > have any more info.
> > >
> > > Erik Mooney
> > > Persits Software Inc.
> > > http://www.persits.com
> > >
> >
> > --------------------------------------------------------------------------
> ------
> > >
> > >
> > > Can anyone help please?
> > >
> > > Shahid M. Syed
> > >
> >
> > --
> > MySQL Bugs Mailing List
> > For list archives: http://lists.mysql.com/bugs
> > To unsubscribe:
> http://lists.mysql.com/[email protected]
> >
> >
> >
>

Sincerely,

-- 
Boyd Gerber, Software Engineer & Support Specialist
MySQL AB, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]