Server error: Unable to retrieve schema information from

Using the procedure in the File Upload
White Paper, on the second asp file I cannot include all
of my fields in the sql statement to INSERT INTO the
database table. I get this error message when trying
to verify the fields in the Access database.
Server error: Unable to retrieve schema information from
the query:

INSERT INTO BidList (Company_Name,ContactFirstName,
ContactLastName,Mailing_Address,Title,Mailing_Address2,Coun
try,City,Phone,Mailing_State,Fax,Zip,Email,Shipping_Address
,Shipping_City,Shipping_Address2,Shipping_State,Shipping_Zi
p,License,Aggregate_Bond,FedID,Single_Bond,Began,Insurance,
Incorporated,Coverages,Principals,Scope,Bonding,Largest_J

The following error message comes from the database driver
software; it may appear in a different language depending
on how the driver is configured.


When I delete some of the fields it verifies with no
problem. Is there a limit to the size of this
statement or do I just have something wrong in my field
names?

Tim
Sat Nov 22 16:07:43 CST 2003

Did you get a response to this message? I've got the same
issue and had the very same questions. This has been very
frustrating to me.

TIA,
Tim

>-----Original Message-----
>Using the procedure in the File Upload
>White Paper, on the second asp file I cannot include all
>of my fields in the sql statement to INSERT INTO the
>database table. I get this error message when trying
>to verify the fields in the Access database.
>Server error: Unable to retrieve schema information from
>the query:
>
>INSERT INTO BidList (Company_Name,ContactFirstName,
>ContactLastName,Mailing_Address,Title,Mailing_Address2,Cou
n
>try,City,Phone,Mailing_State,Fax,Zip,Email,Shipping_Addres
s
>,Shipping_City,Shipping_Address2,Shipping_State,Shipping_Z
i
>p,License,Aggregate_Bond,FedID,Single_Bond,Began,Insurance
,
>Incorporated,Coverages,Principals,Scope,Bonding,Largest_J
>
>The following error message comes from the database
driver
>software; it may appear in a different language depending
>on how the driver is configured.
>
>
>When I delete some of the fields it verifies with no
>problem. Is there a limit to the size of this
>statement or do I just have something wrong in my field
>names?
>
>.
>

grw
Sun Nov 23 13:45:02 CST 2003

Whats your SQL string?


"Tim Black" <anonymous@discussions.microsoft.com> wrote in message
news:03d201c3b145$0db4fa50$7d02280a@phx.gbl...
> Did you get a response to this message? I've got the same
> issue and had the very same questions. This has been very
> frustrating to me.
>
> TIA,
> Tim
>
> >-----Original Message-----
> >Using the procedure in the File Upload
> >White Paper, on the second asp file I cannot include all
> >of my fields in the sql statement to INSERT INTO the
> >database table. I get this error message when trying
> >to verify the fields in the Access database.
> >Server error: Unable to retrieve schema information from
> >the query:
> >
> >INSERT INTO BidList (Company_Name,ContactFirstName,
> >ContactLastName,Mailing_Address,Title,Mailing_Address2,Cou
> n
> >try,City,Phone,Mailing_State,Fax,Zip,Email,Shipping_Addres
> s
> >,Shipping_City,Shipping_Address2,Shipping_State,Shipping_Z
> i
> >p,License,Aggregate_Bond,FedID,Single_Bond,Began,Insurance
> ,
> >Incorporated,Coverages,Principals,Scope,Bonding,Largest_J
> >
> >The following error message comes from the database
> driver
> >software; it may appear in a different language depending
> >on how the driver is configured.
> >
> >
> >When I delete some of the fields it verifies with no
> >problem. Is there a limit to the size of this
> >statement or do I just have something wrong in my field
> >names?
> >
> >.
> >