Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9503 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepak g
You have to use this DSN name (in your case it is sonia) in
your VB code wherever you wish to establish a connection
between your VB application and your SQL server 2K database.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How would you map properties to controls by using ActiveX Control Interface Wizard?
i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI).
Types of LockEdits in RDO.
How many ways you can access file using VB?
Differentiate between DAO,ADO and Adodc as in data access objects?
How many ways we can access file using VB?
With in the form we want to check all the text box control are typed or not? How?
Write the Steps in Creating an ActiveX Control?
It possible to call OLEDB?s Features directly in VB without using any control?
Explain about manipulating the recordset object
What is ODBC Direct and Microsoft Jet Database Engine ?
Which type of object requires this object?
what is the Property used to add a menus at runtime?
What is visual basic used for?
How would you use ActiveX Dll and ActiveX Exe in your application?
