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.
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
Can any one please suggest which institute is providing Advance Excel & VBA Macros in Excel training in Hyderabad.
how to use telugu language in vb6? any unicode data is available for telugu or not?yes means how to use? my desired output is telugu only? i am doing project like(telugu calendar),my output should be print in telugu only? pls send me the solution with code?
what are the Types of LockEdits in RDO?
What are the Internet tools available in VB 6.0?
How would you attach an ActiveX control in Your Application?
how to use unicode data in vb6 regarding to telugu language, my output is in only telugu language
What do you mean by Databound Controls Explain?
What is ActiveX? Explain.
How do you change the system menu (on the Control-Menu Box)?
What is DDE?
Types of cursors in RDO.
What are 3 main differences between flexgrid control and dbgrid control?
How many tabs in a tabbed dialog do you consider appropriate?
What are the Internet tools available in VB6.0?
Explain about arrays?