Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
How To Configure and Test ODBC DSN Settings?
Submitted by: AdministratorContinue from the previous tutorial. Click Next after you have finished changing the port number. The ODBC Data Source Administrator will try to connect to the SQL server through the specified port number and login information.
If the connection is successful, you will see the next screen asking for selecting default database.
1. Check "Change the default database to:" check box, and select "GlobalGuideLineDatabase" as the default database for this DSN setting. See picture bellow:
ODBC DSN Default Database Selection
2. Click Next to see the last screen of the "Create a New Data Source to SQL Server" wizard.
3. Change nothing on the last screen and click Finish button. The confirmation screen shows up.
4. Click "Test Data Source..." button. You should see the test result as:
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
Your ggl_SQL_SERVER ODBC DSN is ready to use.
Submitted by: Administrator
If the connection is successful, you will see the next screen asking for selecting default database.
1. Check "Change the default database to:" check box, and select "GlobalGuideLineDatabase" as the default database for this DSN setting. See picture bellow:
ODBC DSN Default Database Selection
2. Click Next to see the last screen of the "Create a New Data Source to SQL Server" wizard.
3. Change nothing on the last screen and click Finish button. The confirmation screen shows up.
4. Click "Test Data Source..." button. You should see the test result as:
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
Your ggl_SQL_SERVER ODBC DSN is ready to use.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.