Connectivity of SQL 2000 + Vb. Using ODBC.

Answer Posted / sonia.sardana

steps i Follow-
1) Go to Control panel-->Admintrative Tools-->Double -click
Data sources(ODBC)-->click Add button-->I choose SQL server
(last option), Is it right or wrong option for connecting
to SQL 2000.Then a new screen appears Create a New
dataSource-->in name textbox,we can write anyname--Right or
wrong. suppose i enter sonia, & my server name is .,so I
enter . in server & click next button-->On the Next screen
i have checked the option With Sql server authentication--
>Login Id-sa, Password-->Blank-->Click next button-->Next--
>Finish-->Then I click on button Test Data source-->Mesage
Comes TESTS COMPLETED SUCCESSFULLY-->OK-->OK-->Ok.

These steps we have to do or not for Connectivity using
ODBC.
If yes,then what after these steps we have to do??Plz reply
me early ??Thx in advance.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is iis configuration?

514


Explain different IIS Isolation Levels?

565


What is iis and how do you use it?

498


What is worker process?

517


What is recycling in iis?

501






What is the use of virtual directory in iis?

492


What is a virtual directory in iis?

546


What is the role of http.sys in iis?

490


What is default web site in iis?

511


How do I install a certificate?

524


Explain how to create a virtual directory on iis?

488


What version is iis?

521


How do you uninstall iis apps?

516


What is iis used for?

484


What is iis and why it is used?

472