You have to create the DSN programatically by using some code.

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 / ramu.m

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

Please Help Members By Posting Answers For Below Questions

Can you tell me the properties of the controls?

2081

What do you know about user forms.

1155

Explain the creation project schedule.

1113

What is FireHouse Cursors?

2339

___ is the control used to call a windows application.

1593

How can I access a record by record number?

1598

How would you attach pictures in Treeview Control?

2031

How can you get selected file from file system Control?

2052

what are the Parts of ODBC?

1892

It possible to call OLEDB?s Features directly in VB without using any control?

2150

What language does visual basic use?

1010

How do you zoom in visual basic?

1009

Which method is used to write context Into file?

2089

Explain the types of Views in Listview Control?

2295

what are the Differences between Recordset and Resultsets?

2578