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
- 9314 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 would you add elements in TreevieW Control?
What are the different procedures associated with the object?
Can you tell me the properties of the controls?
Can you create a updatecascade, Deletecascade relation in Ms- Access? If no, give on eample.
What is the difference between change event in normal combobox and dbcombobox?
Why do I get "object not an array" when I try reference the fields of a global object variable which I have set to a table?
What is the use of Visual Basic Document file?
What is the use of parameters collection?
which property is used to change to some value to access a identity column in datacontrols?
which method used to move a recordset pointer in nth position in DAG?
Is it posible to Create Tables Through Querydef?
What are the Internet tools available in VB 6.0?
Explain about conditional operators?
What is Parser Bug?
Is there a way to break long lines in VB code?
