you can try this for the perticular user in sql 'Set con = New Conn

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.

Question Posted / vikas gupta`

6 Answers
9260 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

Please Help Members By Posting Answers For Below Questions

What are the types of line styles available in Treeview Control?

1880

How do I change the color of a form in visual basic?

941

Draw Sequence Modal of DAO and Explain?

1982

Types of DBCombo boxes

2037

___,__,___ are the type of combo box?

1575

Write the Steps in Creating an ActiveX Control?

2572

What is the-use of property page Wizard in ActiveX Control?

1992

Discuss the working with to-do lists.

1024

What is Mask Edit and why it is used?

1879

How would you map properties to controls by using ActiveX Control Interface Wizard?

2219

How do I speed up control property access?

1452

Types of LockEdits in DAO?

2080

How to use advanced data-bound controls.

1133

Explain about literals?

982

How would you add elements in TreevieW Control?

1999