HELP! DATABASE CONNECT ERROR

[Debbie]

I have manage a website for over a year now. I created a
database with the wizard and everything has always worked
fine. Well, I went in and added a couple of fields and
now I get this error message when trying to connect to the
database through frontpage.

SERVER ERROR: UNABLE TO RETRIEVE THE LIST OF RECORD
SOURCES FROM A DATABASE USING THE CONNECTION STRING.

DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/loans.mdb.

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


Source: ADO
Number: -2146825037 (0x800a0cb3)

When I go to the webpage I get the following error:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
System resource exceeded.
Number: -2147024882 (0x8007000E)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide
default values for all form fields that are used in the
query.

 

[Paul Andrew]

Debbie,
The first thing that I would do is download the
database to your local computer and look at any records
created since you made those changes. You may have
inadvertantly set one of the new fields up so that the
value can't be null, which would be a problem since all
the previous records wouldn't have any data in them.
After that I would try and create a new connection to
the database via the connection manager and see if that
works. Let me know what you find out and I'll see what
else I can do for you.

Paul

 

[Debbie]

Thanks for the suggestion. It didn't work. I looked at
my database in access and all fields are set to text and
none are required fields. I have no fields set up as
numbers or dates. I've had that problem before so I make
them all text.
I can't even get a connection to the northwind sample
database. I have another website which is also hosted by
bcentral. I moved my database to this website and still
cant connect to it. I created a new web on my other site
and it worked fine. What in the world is going on?

-----Original Message-----
Debbie,
The first thing that I would do is download the
database to your local computer and look at any records
created since you made those changes. You may have
inadvertantly set one of the new fields up so that the
value can't be null, which would be a problem since all
the previous records wouldn't have any data in them.
After that I would try and create a new connection to
the database via the connection manager and see if that
works. Let me know what you find out and I'll see what
else I can do for you.

Paul

-----Original Message-----
I have manage a website for over a year now. I created a
database with the wizard and everything has always worked
fine. Well, I went in and added a couple of fields and
now I get this error message when trying to connect to the
database through frontpage.

SERVER ERROR: UNABLE TO RETRIEVE THE LIST OF RECORD
SOURCES FROM A DATABASE USING THE CONNECTION STRING.

DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=URL=fpdb/loans.mdb.

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


Source: ADO
Number: -2146825037 (0x800a0cb3)

When I go to the webpage I get the following error:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver]
System resource exceeded.
Number: -2147024882 (0x8007000E)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide
default values for all form fields that are used in the
query.
.

.

 

[grw]

"System resource exceeded." ?
Have you talked to your host?

 

[Kevin Spencer]

I'm not sure what you mean by "connect to the database through frontpage,"
but the second part of your message indicates that the Connection String in
your global.asa file is indeed working, and that the ASP form handler is
unable to insert a new record because of the new columns you added which
apparently don't allow null values (require a value to be inserted). At this
point, your best bet would be to re-run the Wizard from the start, as if you
had not done it before, in order for FrontPage to construct new queries that
include the new columns.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.