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
- 9345 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 a multiple routing works ?
Write the Steps in Creating an ActiveX Control?
When/Why should I use Option Explicit?
What is meant by Establish Connection in RDO?
How can I change the printer Windows uses in code without using the print common dialog? How can I change orientation?
What are the rules which should be followed while naming a variable in VB?
To.set the command button for ESC ___ Property has to be changed.
Which method is preferred to save data like database to the disk?
How do I tell when an application executed using the SHELL command is finished?
Explain what is Visual basic?
How do I call a DLL?
What is DAO?
Explain OLE Drag and Drop.
Which method is used to write context Into file?
How can you Navigate from the DHTML application to another DHTML application? .
