Limit to the number of databases - ?

I have created an ASP page that accesses a number of different databases. Is
there a limit to the number of databases to which I can connect from one
page? Right now my page won't load in Internet Explorer (whereas it was
loading fine before). Could the number of databases be my problem?


-- Nate

There is no limit that I know of, but pulling from multiple dbs on 1 page
does stress the server, particularly if these are Access db's . Have you
ever thought of just copying the all db tables to one db? Are you getting an
error on the page? Did you disable friendly http errors in IE

~Bill Schroyer www.g2w.net/FrontPage_Help

"montiy" <montiy@discussions.microsoft.com> wrote in message
news:2A80431C-1F1F-4DD2-A12C-6CD2666AE580@microsoft.com...
>I have created an ASP page that accesses a number of different databases.
>Is
> there a limit to the number of databases to which I can connect from one
> page? Right now my page won't load in Internet Explorer (whereas it was
> loading fine before). Could the number of databases be my problem?
>
>
> -- Nate
>

I wasn't getting an error -- just I'd get one of those "page cannot be
displayed" types of things in IE.

This morning it's not doing it anymore -- it's fine now.

Do you think I could have just been stressing the server too much?

Hadn't thought of just doing multiple tables in the same DB. Good idea.

-- Nate


"Hosting" wrote:

> There is no limit that I know of, but pulling from multiple dbs on 1 page
> does stress the server, particularly if these are Access db's . Have you
> ever thought of just copying the all db tables to one db? Are you getting an
> error on the page? Did you disable friendly http errors in IE
>
> ~Bill Schroyer www.g2w.net/FrontPage_Help
>
> "montiy" <montiy@discussions.microsoft.com> wrote in message
> news:2A80431C-1F1F-4DD2-A12C-6CD2666AE580@microsoft.com...
> >I have created an ASP page that accesses a number of different databases.
> >Is
> > there a limit to the number of databases to which I can connect from one
> > page? Right now my page won't load in Internet Explorer (whereas it was
> > loading fine before). Could the number of databases be my problem?
> >
> >
> > -- Nate
> >
>
>
>

Possibly, you can very easily hang a server just by a bad script.

If this is a remotely hosted site, ask your provider if there's a way
you can start and stop the web service. If it happens again, stop
and start the service. Then you'll know for sure.



_____________________________________
~Bill Schroyer www.g2w.net/FrontPage_Help



"montiy" <montiy@discussions.microsoft.com> wrote in message
news:E0B41305-CB9F-41AE-B703-A85AA56063DD@microsoft.com...
>I wasn't getting an error -- just I'd get one of those "page cannot be
> displayed" types of things in IE.
>
> This morning it's not doing it anymore -- it's fine now.
>
> Do you think I could have just been stressing the server too much?
>
> Hadn't thought of just doing multiple tables in the same DB. Good idea.
>
> -- Nate
>
>
> "Hosting" wrote:
>
>> There is no limit that I know of, but pulling from multiple dbs on 1 page
>> does stress the server, particularly if these are Access db's . Have you
>> ever thought of just copying the all db tables to one db? Are you getting
>> an
>> error on the page? Did you disable friendly http errors in IE
>>
>> ~Bill Schroyer www.g2w.net/FrontPage_Help
>>
>> "montiy" <montiy@discussions.microsoft.com> wrote in message
>> news:2A80431C-1F1F-4DD2-A12C-6CD2666AE580@microsoft.com...
>> >I have created an ASP page that accesses a number of different
>> >databases.
>> >Is
>> > there a limit to the number of databases to which I can connect from
>> > one
>> > page? Right now my page won't load in Internet Explorer (whereas it
>> > was
>> > loading fine before). Could the number of databases be my problem?
>> >
>> >
>> > -- Nate
>> >
>>
>>
>>