Answer Posted / Vikram Pandey
"To define the name and server for a new Data Source Name (DSN) in MS SQL Server, you can use the ODBC Data Source Administrator tool. Here's how:nn1. Open Control Panel.n2. Click on Administrative Tools > Data Sources (ODBC).n3. Click on the `System DSN` tab and then click `Add...`.n4. Select `SQL Server` as the data source, click `Finish`, then fill in the server name and name for your new DSN."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we do dml on views?
What is the difference between upgrade and migration in sql server?
What are the kinds of subquery?
How to convert character strings into numeric values?
What are different types of constraints?
What kind of problems occurs if we do not implement proper locking strategy?
How can you append an identity column to a temporary table?
What is a coalesce function?
What is a view in sql?
What is subquery? Explain the properties of a subquery?
List the ways in which dynamic sql can be executed?
Explain system functions or built-in functions? What are different types of system functions?
What are the properties of the transaction?
How can we solve concurrency problems?
What are the source of constraints?