Server error: Unable to retrieve schema information from

K

kaykay

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?
 
T

Tim Black

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
 
G

grw

Whats your SQL string?


Tim Black said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top