微软认证考试：模拟题(iis)

微软认证考试：模拟题（iis）

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 D

B Provider for ODB

C 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:

/support/kb/articles/q183/0/60.asp

and

/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 driver specified.

the most common cause is that the connection string is a session variable initialized in the Global.asa and Global.asa is not firing. You may check to see that the variable is being initialized correctly by adding the following code to the .asp page:

- If the Global.asa is not firing, check to make sure it is in an Application Root for IIS 4.0, or a Virtual Root with the "Execute" check box selected if running under IIS 3.0. Also, a bug detailed in the Microsoft Knowledge Base article Q173742, may prevent the Global.asa from being fired when Windows NT permissions have restricted access to the folder.

- The DSN name is not found. Check to make sure a 'User' type DSN is not being used.

- If using a File or System DSN, try changing the connection string to "DSN=MySystemDSN" or "DBQ=MyFileDSN" as appropriate. Simplify!

- Check to make sure that the most current drivers are installed. If in doubt, download the latest MDAC (Microsoft Data Access Components) from the following Web site:

Error Message ------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' Microsoft][ODBC Microsoft SQL Driver] Logon Failed() Cause -----