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
- 9273 Views
- I also Faced
- E-Mail Answers
Answer Posted / abdul khadeer
After creating the DSN. You can use that DSN to access the
DATA.
For Example U Can Use the ADODB connection Object to
connect the Database by using ur DSN created.
For Example Say "Con" is object ADODB.Connection
Then open ur coonection.
Con.Open "MyDSN","UserName","Password"
Now the conection created, Now u can use this connection
object with ur record set oject to retirve the data
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ActiveX? Explain.
How would you add elements and pictures to listitems in listview control?
Explain the usage of Web Browser Control?
How can I create a VBX?
How can you Implement windows functionality in VB?
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 is Parser Bug?
How do I make an animated icon for my program?
Recordset object consists what?
How many types of API functions are available in VB?
Draw Sequence Modal of RDO and Explain?
Types of cursors in RDO.
1s it posible to Create Tables Through Querydef?
What is executenonquery in vb net?
What is snapshot in vb?
