Re: Problem with ASP queries to database

The error message that you are getting is the generic "I can't find this 
database" message. Without actually seeing the code in sites.asp, here are 
potential causes:

1) The most likely explanation is that you have a DSN connection to the 
database and that DSN connection has been dropped.

There are a couple of ways this can happen. If you deleted the database 
before you uploaded the new database, it's possible that you killed the DSN 
connection. If you changed locations of the database you might have killed 
the DSN. If you renamed the database, the DSN will be dropped.

You can tell that you have a DSN connection by looking for a line that says 
something like DSN= somewhere probably near the top of sites.asp. This 
problem can be fixed by asking your host to reset the DSN.

2) Another possibility is that your ISP has the server set so that 
permissions have to be turned on explicitly. However, you might want to make 
sure that you have read/write capability to the database.

3) The safest way to eliminate this problem is to specify the driver and 
full path to the database. (A DSN-less connection.) If you know the full 
path ot the database, you might try this type of connection and see if the 
problem goes away. (Most likely, it will.)



Eric Anderson
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA