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
- 9317 Views
- I also Faced
- E-Mail Answers
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 much gain in performance will I get if I write my number crunching routines in C instead of Visual Basic?
___ property is used to change to ___ value to access a identity column'in datacontrols.
What is snapshot in vb?
___ is the control used to call a windows application.
How can you filter out specific type of file using file system controls?
What is rdo in vb?
Explain about control properties?
___ property used to add a menus at runtime.
How can I access a record by record number?
Differentiate between DAO,ADO and Adodc as in data access objects?
What is a toolbox in visual basic?
___,__,___ are the type of combo box?
What are the Internet tools available in VB 6.0?
What is ado data control in vb?
Parts of ODBC?
