I am running SQL 2005 on a server 2k3 box and I am using asp to upload images
into my database. Everything works fine except when I upload anything over
2,000,000 bytes. The image will end up getting cut off due to only the first
2,000,000 bytes being uploaded. I have made all the edits I think I can
within metabase, but maybe I am missing something. I dont know if it is a
IIS, SQL or ASP issue yet.
On Jul 6, 4:32 pm, JohnX
> I am running SQL 2005 on a server 2k3 box and I am using asp to upload images
> into my database. Everything works fine except when I upload anything over
> 2,000,000 bytes. The image will end up getting cut off due to only the first
> 2,000,000 bytes being uploaded. I have made all the edits I think I can
> within metabase, but maybe I am missing something. I dont know if it is a
> IIS, SQL or ASP issue yet.
Sounds like user misconfiguration of the SQL database column to not
support >2million bytes.
- IIS does not have such an upload limit.
- IIS also does not know nor care about the data so the fact that it
is Images is not relevant.
- ASP upload limit does not allow 2million byte uploads by default, so
the fact you are getting to 2million tells me you've tweaked that
value
- SQL table that stores this value is of unknown configuration
//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//
"David Wang" wrote:
> On Jul 6, 4:32 pm, JohnX
> > I am running SQL 2005 on a server 2k3 box and I am using asp to upload images
> > into my database. Everything works fine except when I upload anything over
> > 2,000,000 bytes. The image will end up getting cut off due to only the first
> > 2,000,000 bytes being uploaded. I have made all the edits I think I can
> > within metabase, but maybe I am missing something. I dont know if it is a
> > IIS, SQL or ASP issue yet.
>
> Sounds like user misconfiguration of the SQL database column to not
> support >2million bytes.
>
> - IIS does not have such an upload limit.
> - IIS also does not know nor care about the data so the fact that it
> is Images is not relevant.
> - ASP upload limit does not allow 2million byte uploads by default, so
> the fact you are getting to 2million tells me you've tweaked that
> value
> - SQL table that stores this value is of unknown configuration
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //
>
>
Currently I am using asprunner to desing my asp pages and accoring to the
designer of asprunner the problem is within IIS.
My configuration of IIS is tweeked to allow files over the 8mb range
My SQL config is a basic non tweeked table. and setup as such
ID= int
photo=image
comment=text
folder value=text
zero changes have been made to the SQL side
On Jul 6, 6:04 pm, JohnX
> "David Wang" wrote:
> > On Jul 6, 4:32 pm, JohnX
> > > I am running SQL 2005 on a server 2k3 box and I am using asp to upload images
> > > into my database. Everything works fine except when I upload anything over
> > > 2,000,000 bytes. The image will end up getting cut off due to only the first
> > > 2,000,000 bytes being uploaded. I have made all the edits I think I can
> > > within metabase, but maybe I am missing something. I dont know if it is a
> > > IIS, SQL or ASP issue yet.
>
> > Sounds like user misconfiguration of the SQL database column to not
> > support >2million bytes.
>
> > - IIS does not have such an upload limit.
> > - IIS also does not know nor care about the data so the fact that it
> > is Images is not relevant.
> > - ASP upload limit does not allow 2million byte uploads by default, so
> > the fact you are getting to 2million tells me you've tweaked that
> > value
> > - SQL table that stores this value is of unknown configuration
>
> > //David
> >http://w3-4u.blogspot.com
> >http://blogs.msdn.com/David.Wang
> > //
>
> Currently I am using asprunner to desing my asp pages and accoring to the
> designer of asprunner the problem is within IIS.
>
> My configuration of IIS is tweeked to allow files over the 8mb range
>
> My SQL config is a basic non tweeked table. and setup as such
>
> ID= int
> photo=image
> comment=text
> folder value=text
>
> zero changes have been made to the SQL side- Hide quoted text -
>
> - Show quoted text -
The problem is not within IIS nor ASP because it allows and supports
uploads greater than that size. If you got to 2million bytes being
truncated, you've tweaked the right values to get there.
If ASPRunner says the problem is not in the ASP application itself,
then you can only start looking at the SQL configuration.
//David
http://w3-4u.blogspot.com
http://blogs.msdn.com/David.Wang
//