ASPJpeg

------=_NextPart_000_0088_01C3CE99.53350E50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,
I sent the following email to ASPJpeg support:

------------------------------------------------------------ -------------=
-------


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

------=_NextPart_000_0088_01C3CE99.53350E50--

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/bugs?unsub=gcdmb-bugs@m.gmane.org

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"
> To: "Shahid M. Syed"
> Cc:
> 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/bugs?unsub=shahid@desiwriters.com
> >
> >
> >
>

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/bugs?unsub=gcdmb-bugs@m.gmane.org