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
- 9622 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 would you attach pictures in column headers of List View Control?
Draw Sequence Modal of DAO and Explain?
Specify technical & functional architecture of your last 2 projects.
With in the form we want to check all the text box control are typed or not? How?
How do I tell when an application executed using the SHELL command is finished?
How do I make the mouse cursor invisible/visible?
How would you activate animation control?
How do I force a file dialogue box to reread the currect disk?
