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
- 9069 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 to control the file?
Which method is preferred to save datas like database?
Explain the usage of Web Browser Control?
What is the difference between Msgbox Statement and MsgboxQ function?
What is recordset in visual basic?
How do I call help files from a VB program?
How do I call a DLL?
How do I program the Novell NetWare API from VB?
VB ActiveX: Create a "drivelist"(D1) box, a "folderlistbox"(FLD1) that changes whenever D1 is changed , and a "FilelistBox"(FIL1) that is populated with the file lists under the selected directory in (D1).The file selected is stored in a variable "filename" along with the path. Question: How to use this activeX control in VC++ to get the selected filename?
How do I do Peek and Poke and other low-level stuff?
Is it possible to change menu runtime using API? If yes Specify the function names?
what are the Types of Resultsets?
What are the Differenct Types of Instancing Property in ActiveX Dll and Exe?
__ no of controls in form.
How can I speed up my VB database application?
