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

How many security types are available on IIS?

773


How do I check the version of iis?

700


How do I reset iis in windows 10?

702


Where are iis backups stored?

657


How do I start and stop iis?

689


What is an iis application?

741


What are the tools used for editing in iis?

707


What is the service name for iis?

718


How do I stop a service from the command line?

681


How do I open iis manager in windows 10?

718


How do I create a iis application?

678


What is iis and how does it work?

710


Where is the iis manager in windows 10?

735


Is iis considered middleware?

1167


IIS Performance tuning

2646