Application.cfm problem on new server

[GoBigOrange]

We have a disgruntled situation with an ex-programmer who has left us holding
the bag. We are trying to move a web site from 2globalmart.com to another
server running IIS6.0 and CF 5 SQL2k. 2global appears to be running iis5.0
right now.

We have other CF applications on the newer server which run fine and use an
application.cfm file for the SQL database connections.

The server logs indicate a failed data connection as follows:
"Error","1892","06/07/05","19:28:24",,"ODBC Error Code = S0002 (Base table not
found)<P> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'players'.<P><P> SQL = ""SELECT * FROM players WHERE type = 'player'
ORDER BY playerNum ASC"" ""

The HTTP browser displays the following error message:

Processing Error
This web site has experienced an error while processing your request.

Please try your request again at a later time.


If I remove the application.cfm file from other working web sites, I get that
same error message above, so I assume for some reason on this site it is not
able to find the application.cfm file. So that is where I am stumped.

I have connected to the SQL database using Enterprise Manager so the
username/password in the application.cfm file is correct.

Any help is appreciated! Thanks in advance.

[MikerRoo]

The SQL login, for this application, probably has a default database of
"Master" or some such.

In Enterprise Manager, set the login's default database to the correct name
for this app.

Was the old database also SQL Server 2000?