CONNECTIVITY OF SQL 2000 + VB USING ODBC.
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.
- 6 Answers
- 9621 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramu.m
You have to create the DSN programatically by using some
code.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Specify technical & functional architecture of your last 2 projects.
With in the form we want to check all the text box control are typed or not? How?
How would you attach pictures in column headers of List View Control?
How do I force a file dialogue box to reread the currect disk?
How do I tell when an application executed using the SHELL command is finished?
Draw Sequence Modal of DAO and Explain?
How would you activate animation control?
How do I make the mouse cursor invisible/visible?
