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 microsoft's web server?

576


What is the use of creating virtual directory in iis?

552


Describe the different types of identity available in iis 6.0?

564


What is iis? Why is it used?

597


How do I start iis from command line?

594






Explain how to create a virtual directory on iis?

559


What does iis recycle do?

594


What is application pool in iis?

599


How do I install iis admin?

572


How do I uninstall iis?

651


What are the iis versions?

574


computer hardware used and its function

3221


What are the different types of identity available in iis 6.0?

600


What is windows process activation service?

609


How do I open iis manager?

599