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
- 9318 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
What is visual basic used for?
How do I implement Undo?
What is the use of parameters collection?
How many File System Controls are there Explain?
What is ado in vb?
What is form in visual basic?
How do I force a file dialogue box to reread the currect disk?
How would you attach an ActiveX control in Your Application?
What is the Windows API?
Is there any way to pass a variable to a form apart from using global variables?
What are the types of line styles available in Treeview Control?
How do I make an animated icon for my program?
what are the Differences between Recordset and Resultsets?
How do I create a window with a small title bar as in a floating toolbar?
How many ways we can access file using VB?
