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
- 7440 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
___,___ arguments will be used to run a executable program in shell function
How can I change the printer Windows uses in code without using the print common dialog? How can I change orientation?
Explain about ADO control?
How do I create controls dynamically (at run-time)?
Draw Sequence Modal of DAO and Explain?
What is ActiveX Control?
How would you create properties by using class Builder Wizard?
Is it possible to Access BackEnd procedures?
What's the difference between MODAL and MODELESS forms?
what is the Property used to add a menus at runtime?
What is the use of OLE?
What is the use of debug Window?
What is the use of Hyperlink control for DHTML applications?
How do I set the Windows wallpaper at runtime?
Which method is preferred to save datas like database?
