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
What is ado data control in vb6 0?
What is activex control in vb?
What is the use of Hyperlink control for DHTML applications?
How can I create a VBX?
Can you create a Updatecascade, Deletecascade relation in Ms- Access?
Types of cursors in RDO.
How do I mimic a toggle button?
___ is the control used to call a windows application.
What is instantiating?
What is form in visual basic?
Types of LockEdits in RDO.
What is ODBC Direct and Microsoft Jet Database Engine ?
Write the Steps in Creating an ActiveX Control?
Discuss the working with to-do lists.
Explain the creation project schedule.