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 / vikas gupta`
you can try this for the perticular user in sql
'Set con = New Connection
'con.ConnectionString = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;Initial
Catalog=account;Data Source=."
'con.Open
'Set rec = New Recordset
'rec.Open "select * from acc_details", con, adOpenDynamic,
adLockOptimistic
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How would you navigate between one document to another document
what is use of book mark in excel ? send answer in my id ashishpal11@rediffmail.com
What is Internet Explorer and its uses?
How would you add elements and pictures to listitems in listview control?
How many ways you can access file using VB?
How do I access C style strings?
How to use advanced data-bound controls.
What is FireHouse Cursors?
___,___ arguments will be used to run a executable program in shell function
Explain the types of Views in Listview Control.
What is meant by Establish Connection in RDO?
How do you zoom in visual basic?
What is data control in vb?
Is visual basic still used?
What is hyperlink?