After creating the DSN. You can use that DSN to access the DATA. For Ex

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.

Question Posted / abdul khadeer

6 Answers
9062 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

Please Help Members By Posting Answers For Below Questions

Explain about form creation in Visual Basic?

1210

What is the difference between Msgbox Statement and MsgboxQ function?

1874

how a multiple routing works ?

2785

Difference between Recordset and Resultsets.

4026

___,__,___ are the type of combo box?

1541

Explain about ADO control?

952

OLE is used for _______

1550

Explain about the basic features of Visual basic?

972

Is visual basic easy?

960

Difference between Linked Object and Embedded Object?

2211

How to down load image properties.

1007

which property is used to change to some value to access a identity column in datacontrols?

1768

How do I tell when an application executed using the SHELL command is finished?

1484

What is the use of Visual Basic Document file?

2761

What is constructors and distructors.

2233