Why Is DWMX So Buggy with db Connections?

[KingDubbya]

Does anyone else have these problems?

1.) Everytime you switch between the bindings and server behavoirs panel the
"Loading Database Schema.." box pops up. This only happens on certain pages at
certain times. At times it will leave this message up for a couple of minutes
until the server times out. If you cancel out of this dialog box it looses the
connection to the database.

2.) You finish coding a page everything appears to be as it should be, there
are no red '!' in your server behaviors, the "Loading Database Schema." box has
not appeared. So you save and upload your file and then try to test it and you
get a 404 error or a "Page Cannot Be Displayed" for no apparent reason. You go
back double check that everything is there and your code appears sound. Finally
you just erase the file and start over, doing everything exactly the same, save
and up load and everything works just fine. Why?

I'd like to hear from others with these problems and solutions to them.

[Joe Ruggeri]

KingDubbya ...

Sounds like you may have a server problem or connectivity issue.

The only time I get the "Loading ... Schema" dialog is if I'm opening up a
recordset that pulls a lot of data out of a big table (in particular, one
update page w/ 40-some fields updating a table with more than 100 fields.
ANd at most, it's a 30-40 second wait.

- jr


"KingDubbya" <webforumsuser@macromedia.com> wrote in message
news:d07n6g$q11$1@forums.macromedia.com...

> Does anyone else have these problems?
>
> 1.) Everytime you switch between the bindings and server behavoirs panel

the

> "Loading Database Schema.." box pops up. This only happens on certain

pages at

> certain times. At times it will leave this message up for a couple of

minutes

> until the server times out. If you cancel out of this dialog box it looses

the

> connection to the database.
>
> 2.) You finish coding a page everything appears to be as it should be,

there

> are no red '!' in your server behaviors, the "Loading Database Schema."

box has

> not appeared. So you save and upload your file and then try to test it and

you

> get a 404 error or a "Page Cannot Be Displayed" for no apparent reason.

You go

> back double check that everything is there and your code appears sound.

Finally

> you just erase the file and start over, doing everything exactly the same,

save

> and up load and everything works just fine. Why?
>
> I'd like to hear from others with these problems and solutions to them.
>