Limit to the number of databases - ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top