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.