MCSE模拟题（iis）(1) 免费试题下载-免费试卷下载

When you browse an ASP on a web site, you got an error message: ODBC Driver error "80004005" Data source name not found and no default driver specified.

ODBC driver not configured
Database name is not configured correctly
Data source name is not configured correctly
IIS computer cannot resolve the DNS name of the SQL server database
Answer : 3

A user tries to connect to a database via your company website and receives the error (don't know this exactly)Microsoft OLE DB Provider for ODBC Drivers error '80004005'

(the 3 start the same way and end like this):

LOGIN FAILURE
GENERAL NETWORK ERROR
Can not find Name Space and no driver defined.

Each question has the same answers:

the user has insufficient permissions to access the database.
the user has insufficient permissions to access RESOURCES in the database.
recent revisions of the database changed the connection method from named pipes to TCP/IP.
the database was recently moved to another server....
3 questions on SQL ODBC errors:

A user tries to connect to a database via your company website and receives the error "ODBC ..." LOGIN FAILURE ? The user has insufficient permissions to access the database...

A user tries to connect to a database via your company website and receives the error "ODBC ..." General Network Error ? Due to heavy use the database has been recently moved to another server......

A user tries to connect to a database via your company website and receives the error "ODBC ..." SOURCE NAME NOT FOUND OR NO DEFAULT DRIVER FOUND ? Incorrectly configured Data Source Name (DSN) .......

The choices were:

The user has insufficient permissions to access the database.
The user has insufficient permissions to access RESOURCES in the database.
Recent revisions of the database changed the connection method from named pipes to TCP/IP.
Due to heavy use the database was recently moved to another server....
Incorrectly configured Data Source Name (DSN) ....
ODBC stuff from Microsoft themselves

The following resources address 80004005 errors:

http://support.microsoft.com/support/kb/articles/q183/0/60.asp
and
http://support.microsoft.com/support/odbc/faq/faq3663.asp

Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default